| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
RANK without a tie
The values to rank are in K2, N2, Q2, T2, W2, Z2, AC2, AF2, AI2, AL2.
The values are 0, 0, 12, 127, 39, 17, 0, 0, 0, 0 This is the formula I used to get rid of the tie but it is not working - =RANK(K2,($K$2:$AL$2))+(COUNTIF(H$2:J2,K2)) - I used this in K2 and then copies to N2, etc. please help... thanks! jane |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
RANK without a tie
Why aren't you using
=RANK(K2,$K$2:$AL$2)+(COUNTIF($K$2:K$2,K2))-1 -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "jane" wrote in message ... The values to rank are in K2, N2, Q2, T2, W2, Z2, AC2, AF2, AI2, AL2. The values are 0, 0, 12, 127, 39, 17, 0, 0, 0, 0 This is the formula I used to get rid of the tie but it is not working - =RANK(K2,($K$2:$AL$2))+(COUNTIF(H$2:J2,K2)) - I used this in K2 and then copies to N2, etc. please help... thanks! jane |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
RANK without a tie
ah Bob,
you always come up with the right solution! :) thank you! jane "Bob Phillips" wrote: Why aren't you using =RANK(K2,$K$2:$AL$2)+(COUNTIF($K$2:K$2,K2))-1 -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "jane" wrote in message ... The values to rank are in K2, N2, Q2, T2, W2, Z2, AC2, AF2, AI2, AL2. The values are 0, 0, 12, 127, 39, 17, 0, 0, 0, 0 This is the formula I used to get rid of the tie but it is not working - =RANK(K2,($K$2:$AL$2))+(COUNTIF(H$2:J2,K2)) - I used this in K2 and then copies to N2, etc. please help... thanks! jane |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
RANK without a tie
Assuming that the cells between the target cells do not contain
numerical values, try... K2, copied across: =IF(K2<"",RANK(K2,$K$2:$AL$2)+COUNTIF($K$2:K2,K2)-1,"") Hope this helps! In article , jane wrote: The values to rank are in K2, N2, Q2, T2, W2, Z2, AC2, AF2, AI2, AL2. The values are 0, 0, 12, 127, 39, 17, 0, 0, 0, 0 This is the formula I used to get rid of the tie but it is not working - =RANK(K2,($K$2:$AL$2))+(COUNTIF(H$2:J2,K2)) - I used this in K2 and then copies to N2, etc. please help... thanks! jane |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
| Rank(A1,C1:C5) - Rank using 2 ranges | Excel Worksheet Functions | |||
| Rank where lowest value is highest rank | Excel Worksheet Functions | |||
| Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(. | Excel Worksheet Functions | |||
| Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) | |||
Hybrid Mode
