LinkBack URL
About LinkBacks
Hi
A
2.00 8.00 5.00 5.00 3.00 9.00 =RANK(F1,A1:F1,1) =6
The rank formula returns an incorrect result when in the specified range are duplicates.
The result would be 5 not 6 for F1.
Hi
A
2.00 8.00 5.00 5.00 3.00 9.00 =RANK(F1,A1:F1,1) =6
The rank formula returns an incorrect result when in the specified range are duplicates.
The result would be 5 not 6 for F1.
It's not incorrect: that is standard ranking practice. If you have two equal fourth places, the next ranking is sixth (fifth is missed out). If there is a three-way tie for fourth place, the next ranking will be seventh and so on.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
so what is the solution
i want the result to be 5
Try this...
Data Range
This formula entered in B2 and copied down:
=SUMPRODUCT((A2>=A$2:A$7)/COUNTIF(A$2:A$7,A$2:A$7))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you Mr. Tony Valko
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks