Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to solve tie when using the Rank function?
I am currently using the rank function and when a tie occurs they have the same rank. So assume I have three months of sales that are the same... their ranking looks like this 1,1,1 I want it to rank the first occurence and then add 1 to each following rank that is the same so in this example it would return....1,2,3 I hope this is possible. Thanks -- Skeep ------------------------------------------------------------------------ Skeep's Profile: http://www.excelforum.com/member.php...o&userid=30822 View this thread: http://www.excelforum.com/showthread...hreadid=505216 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to solve tie when using the Rank function?
Look at unique rank
http://www.cpearson.com/excel/rank.htm -- Regards, Peo Sjoblom Portland, Oregon "Skeep" wrote in message ... I am currently using the rank function and when a tie occurs they have the same rank. So assume I have three months of sales that are the same... their ranking looks like this 1,1,1 I want it to rank the first occurence and then add 1 to each following rank that is the same so in this example it would return....1,2,3 I hope this is possible. Thanks -- Skeep ------------------------------------------------------------------------ Skeep's Profile: http://www.excelforum.com/member.php...o&userid=30822 View this thread: http://www.excelforum.com/showthread...hreadid=505216 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to solve tie when using the Rank function?
Awsome, it worked. Thanks. -- Skeep ------------------------------------------------------------------------ Skeep's Profile: http://www.excelforum.com/member.php...o&userid=30822 View this thread: http://www.excelforum.com/showthread...hreadid=505216 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining SUMPRODUCT and RANK functions | Excel Worksheet Functions | |||
Rank Function | Excel Discussion (Misc queries) | |||
Changing worksheet cells from within a function | Setting up and Configuration of Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Rank Function | Excel Worksheet Functions |