| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ranking if number is 550
I need to know how to rank a list of numbers but only rank the numbers above
550. Example A 1523 1242 550 890 I need to rank 1523, 1242, 890, and leave 550 out... So the ranking should be 1523:3, 1242:2, and 890:1 Thanx. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Ranking if number is 550
With your numbers in A1:A4, put this formula in B1 and copy down as far as
B4: =IF(A1550,RANK(A1,$A$1:$A$4),"") Is this what you want? "David A." wrote in message ... I need to know how to rank a list of numbers but only rank the numbers above 550. Example A 1523 1242 550 890 I need to rank 1523, 1242, 890, and leave 550 out... So the ranking should be 1523:3, 1242:2, and 890:1 Thanx. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Ranking if number is 550
Have you compared your results with the result the OP asked for?
-- David Biddulph "Stephen" <none wrote in message ... With your numbers in A1:A4, put this formula in B1 and copy down as far as B4: =IF(A1550,RANK(A1,$A$1:$A$4),"") Is this what you want? "David A." wrote in message ... I need to know how to rank a list of numbers but only rank the numbers above 550. Example A 1523 1242 550 890 I need to rank 1523, 1242, 890, and leave 550 out... So the ranking should be 1523:3, 1242:2, and 890:1 Thanx. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Ranking if number is 550
How would it work if I needed the rank in a range of numbers, lets say
between 550 and 855? "Stephen" wrote: With your numbers in A1:A4, put this formula in B1 and copy down as far as B4: =IF(A1550,RANK(A1,$A$1:$A$4),"") Is this what you want? "David A." wrote in message ... I need to know how to rank a list of numbers but only rank the numbers above 550. Example A 1523 1242 550 890 I need to rank 1523, 1242, 890, and leave 550 out... So the ranking should be 1523:3, 1242:2, and 890:1 Thanx. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Top 10 Ranking again | Excel Discussion (Misc queries) | |||
| Top 10 Ranking | Excel Discussion (Misc queries) | |||
| I want to assign a ranking number to a series of values. | Excel Worksheet Functions | |||
| ranking | Excel Worksheet Functions | |||
| Ranking? | Excel Discussion (Misc queries) | |||
Hybrid Mode
