Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function or code?
What would be the best way to look at the value in 6 cells and in
another cell next to it put what its rank is? For example, say you have the following values in 6 different cells 10, 20, 5, 50, 40, 30 and in another cell next to it you want it to put its rank. For example, for 10 you'd display the number 5, 20 would be 4, 5 would be 6, and so on. Any links, ideas, or answer would be great. thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function or code?
use the rank function
syntax =Rank(value,range) On Sep 25, 2:41*pm, hal wrote: What would be the best way to look at the value in 6 cells and in another cell next to it put what its rank is? *For example, say you have the following values in 6 different cells *10, 20, 5, 50, 40, 30 and in another cell next to it you want it to put its rank. *For example, for 10 you'd display the number 5, 20 would be 4, 5 would be 6, and so on. *Any links, ideas, or answer would be great. thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function or code?
Assuming your list of numbers are in A1 to A6, then put this formula in B1 and copy down the formula for each number (B1 to B6) =RANK(A1,$A$1:$A$6,0) Regards, Muppet Man On Sep 25, 7:41*pm, hal wrote: What would be the best way to look at the value in 6 cells and in another cell next to it put what its rank is? *For example, say you have the following values in 6 different cells *10, 20, 5, 50, 40, 30 and in another cell next to it you want it to put its rank. *For example, for 10 you'd display the number 5, 20 would be 4, 5 would be 6, and so on. *Any links, ideas, or answer would be great. thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function or code?
wish i found that earlier.
thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'Code breaking' function | Excel Discussion (Misc queries) | |||
FUNCTION OR CODE ? | Excel Worksheet Functions | |||
how can i call sub or function in vba code | Excel Discussion (Misc queries) | |||
how to use a VLOOKUP function in a VBA code? | New Users to Excel | |||
Function or Code | Excel Worksheet Functions |