Unique Rank Function
Solved
Anonymous user
-
Anonymous user -
Anonymous user -
Hello,
Is there a rank function in Excel that allows for no duplicates?
I have a ranking on one sheet and another sheet searches for the best in that list, and if I have two identical numbers in the ranking, then the other page gives me a lot of errors :)
Configuration: Windows 7 / Firefox 5.0
--
"Never tell your computer you are in a hurry"
Is there a rank function in Excel that allows for no duplicates?
I have a ranking on one sheet and another sheet searches for the best in that list, and if I have two identical numbers in the ranking, then the other page gives me a lot of errors :)
Configuration: Windows 7 / Firefox 5.0
--
"Never tell your computer you are in a hurry"
6 réponses
Why use computing, then? You might as well do it by hand!
The solution I would personally use would be to add a column; if the values were entered in column D:D, I would have put in column E:E the formula =D:D+row()/1000 and I would have calculated the rank from this column E:E ...
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂
The solution I would personally use would be to add a column; if the values were entered in column D:D, I would have put in column E:E the formula =D:D+row()/1000 and I would have calculated the rank from this column E:E ...
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂