Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a column of figures obtained by using the rank function. However, as
usual, they contain duplicates where appropriate eg 3 ones, followed by a four etc. I want to convert the list into a unique set of numbers without any duplicates - and it doesn't matter which order the 3 ones are in but they need to change to 1, 2, 3 etc Can anyone please suggest a way of doing this. TIA V |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
RANK function | Excel Discussion (Misc queries) | |||
Rank function | Excel Worksheet Functions | |||
Rank Function | Setting up and Configuration of Excel | |||
Rank Function | Excel Discussion (Misc queries) | |||
Need help with RANK function | Excel Worksheet Functions |