Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numerating Cells.
Is there a way to numerate cells. For example.
A1=20 A2=22 A3=5 A4=12 The results I want in column B are the following B1=2 B2=1 B3=4 B4=3 Because, A2 is the highest number, A1 is the second highest, A4 is the 3rd highest and finally A3 is the fourth highest. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numerating Cells.
In B1:
=RANK(A1,$A$1:$A$4) Copy down as needed. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "GEM" wrote: Is there a way to numerate cells. For example. A1=20 A2=22 A3=5 A4=12 The results I want in column B are the following B1=2 B2=1 B3=4 B4=3 Because, A2 is the highest number, A1 is the second highest, A4 is the 3rd highest and finally A3 is the fourth highest. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numerating Cells.
Hi
Look at the Rank() function, insert the formula below in B1 and copy it down. =RANK(A1;$A$1:$A$4) Regards, Per On 4 Aug., 20:46, GEM wrote: Is there a way to numerate cells. For example. A1=20 A2=22 A3=5 A4=12 The results I want in column B are the following B1=2 B2=1 B3=4 B4=3 Because, A2 is the highest number, A1 is the second highest, A4 is the 3rd highest and finally A3 is the fourth highest. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions |