Thank you Very much.
Can we have in reverse order, I mean low to high.?
Advance thanks to all members.
Example
Amount Rank
200 4
1002
-50NA
10 1
-5 NA
300 4
On Wed, Aug 26, 2009 at 9:48 AM, vivek agrawal
The third argument of the RANK function specifies the ranking order
Blank or 0 means ascending order
any other positive number or 1 means the other way round
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Aug 26,
Thanks so much
2009/8/25 jsa-dk johannes.saugbj...@mail.tele.dk
ROUNDUP(9235200,23*2;-6)/2000
On Aug 25, 1:39 pm, NOURREDINE BELHAJ nourredine.bel...@gmail.com
wrote:
Hi All,
Hope you are well.
I would like to ROUNDUP the figure below
9,235,200.23 € to 9,500
Can you
Hi Jonell,
Thanks much appreciated.
it works fine.
Regards
Nour
2009/8/26 jonell jon...@live.com.au
On Aug 25, 9:39 pm, NOURREDINE BELHAJ nourredine.bel...@gmail.com
wrote:
Hi All,
Hope you are well.
I would like to ROUNDUP the figure below
9,235,200.23 € to 9,500
Can you
Please see the attached file.
You'll have to do few adjustments to work it out
Joby
--- On Tue, 25/8/09, suresh k brave.sur...@gmail.com wrote:
From: suresh k brave.sur...@gmail.com
Subject: $$Excel-Macros$$ IF condition formula
To: Excel group excel-macros@googlegroups.com
Date: Tuesday,
Hello Vivek,
I could not get the right answer. I need like
Example
Amount Rank
200 3
100 2
-50NA
10 1
-5 NA
3004
Can you plz get it done in the new excel file?. Thanks Advance my friend.
On Wed, Aug 26, 2009 at 1:09
Plz help!
I am looking as mentioned in column G
Plz see attached file.
On Wed, Aug 26, 2009 at 3:47 PM, vinod rao vinod.ma...@gmail.com wrote:
Hello Vivek,
I could not get the right answer. I need like
Example
Amount Rank
200 3
100 2
-50NA
Vidyut...Thanks a ton...!!
Regarding the excel utilities..-I don't think you need any excel utilities
for that.. you just need to change the formula references. One more thing,
which you might want to do is to install both the Analysis Tool packs which
are available in Tools- AddIns.
Best
This will help.Thank you
can you put formula without using Fcolumn, I want to findout the data from E
only because my workshee is restricted to add one more line.? any suggestion
on this plz.
On Wed, Aug 26, 2009 at 4:07 PM, vivek agrawal vivek.agrawa...@gmail.comwrote:
Hope This Helps
Hi Vinod,
Find the attached solution. If it not fullfill your request then let me know.
Regards
Sandeep
- Original Message -
From: vinod rao
To: excel-macros@googlegroups.com
Sent: Wednesday, August 26, 2009 3:53 PM
Subject: $$Excel-Macros$$ Re: Need help on formula
Plz
rows 1157, 1158, 1159 and 1160 also contain positive values. 0.34 so
these would be considered 1
like wise 1162 to 1156 also contain 0.6 which are again positive hence count
to ranks 5-10..
i hope you understand what i want to convey
Thanks and Regards,
Vivek Agrawal
Skype ID -
Dear All,
Can some one snagged for me american wire gauge calculator,
table or formula in excel,
--
Regards,
Mudassar Ramzan
--~--~-~--~~~---~--~~
--
Some important
hi
i got the solution with out extra column
hope this helps
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Aug 26, 2009 at 4:37 PM, vinod rao vinod.ma...@gmail.com wrote:
This will help.Thank you
can you put formula
Hi Nourredine BELHAJ
Try this formula
CEILING(F18,50)/1000
Regards
Sivakumar
On Aug 25, 4:39 pm, NOURREDINE BELHAJ nourredine.bel...@gmail.com
wrote:
Hi All,
Hope you are well.
I would like to ROUNDUP the figure below
9,235,200.23 € to 9,500
Can you please advise ?
Thanks
--
Hi Vinod,
Did you find my solution or not?
This is my seventh mail.
Regards
Sandeep
On Wed, Aug 26, 2009 at 9:50 AM, Prashant Bhawar
prashant.aca...@gmail.comwrote:
On Tue, Aug 25, 2009 at 9:52 PM, vinod rao vinod.ma...@gmail.com wrote:
Hello Team,
How do i rank only positive numbers.
I have not been successful in move data from one sheet to another when
the destination sheet (sheet3 in this case) has been hidden using the
following:
Sheets ( “sheet3” ) . Visible = x1VeryHidden
When I unhide sheet3 the following Macro works fine.
Sub Move_Data()
'
' Move_Data Macro
'
Hello group,
after spending hours on the web searching for an answer i resort to
you with my noob-question:
How do I combine separated ranges of a worksheet like
Range(A1:B2, C3:D4).Name = RangeName
using R1C1 references as in (pseudocode)
Range(Cells(1,1):Cells(2,2), Cells(3,3):Cells(4,4)).Name
Simple and best
=CEILING(9235200.23,50)/1000
hope this helps
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Aug 26, 2009 at 12:50 AM, jsa-dk johannes.saugbj...@mail.tele.dkwrote:
ROUNDUP(9235200,23*2;-6)/2000
Hi
You can use the union function
it takes as argument various ranges you want to combine...
eg..
Dim MyRange as Range
Set MyRange = union(Range(A1),Range(A2), ..)
hope this helps
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com -
Hi Epi,
One way is to use the Union thingy
Union(Range(Cells(1, 1), Cells(2, 2)), Range(Cells(3, 3), Cells(4, 4))).Name =
RangeName
Regards - Dave
Date: Wed, 26 Aug 2009 18:14:05 -0700
Subject: $$Excel-Macros$$ Combine multiple ranges using R1C1
From: epi_cen...@hotmail.com
To:
Hi Tomy,
I think the problem is that you have the macro 'Selecting' the range which is
xlveryhidden.
Such a range can't be seleceted, but XL doesn't have to select a cell to work
on it.
Try the following code lines instead of what you have.
Sub Move_Data()
'
' Move_Data Macro
' Macro
Hi Everybody,
I have created a macro in personal macro workbook, and saved it, it worked
very good as per my expectation, but now
when I run again the macro, it did'nt work the message like Personal Macro
workbook should be open.
Is there anybody to help me ?
REHAN BAIG
for that you need to open the personal workbook in order to run a macro
from any workbook... you need to have that workbook open
i have windows 7 installed and excel 2007... so the path for personal
workbook for me is the below..
C:\Users\Vivek\AppData\Roaming\Microsoft\Excel\XLSTART\
23 matches
Mail list logo