Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you rank in order numbers from highest to the lowest?
For Example
How would I rank these numbers in order from highest to the lowest Current Points Current Place 46 48 44 44.5 48 44 44 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you rank in order numbers from highest to the lowest?
Using the "Large" function - "=Large( array, 2 )" will return the second
largest number in the array. Regards, Bill "Anika" wrote: For Example How would I rank these numbers in order from highest to the lowest Current Points Current Place 46 48 44 44.5 48 44 44 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you rank in order numbers from highest to the lowest?
With data in A2 to A8, enter this in B2, and copy down:
=RANK(A2,$A$2:$A$8) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Anika" wrote in message ... For Example How would I rank these numbers in order from highest to the lowest Current Points Current Place 46 48 44 44.5 48 44 44 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you rank in order numbers from highest to the lowest?
Thank you. It works brilliantly!
"RagDyer" wrote: With data in A2 to A8, enter this in B2, and copy down: =RANK(A2,$A$2:$A$8) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Anika" wrote in message ... For Example How would I rank these numbers in order from highest to the lowest Current Points Current Place 46 48 44 44.5 48 44 44 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you rank in order numbers from highest to the lowest?
If you don't want the duplicates ranked the same
=RANK(A2,A$2:A$10)+COUNTIF(A$2:A2,A2)-1 "Anika" wrote: For Example How would I rank these numbers in order from highest to the lowest Current Points Current Place 46 48 44 44.5 48 44 44 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
average of highest 48 of 52 radom numbers with duplicate low #'s | Excel Worksheet Functions | |||
Rank where lowest value is highest rank | Excel Worksheet Functions | |||
Sort from lowest to highest | Excel Worksheet Functions | |||
Find lowest and highest value from a set of rows | Excel Discussion (Misc queries) | |||
Tie breaking in a rank order | Excel Worksheet Functions |