Hi everyone,
I was trying to do a more advanced ranking for two columns A and B. Both columns are numeric values and there are duplicates.
The idea is trying to sort data by column A and then by column B. The formula that I used is:
Please see the sample file here. The trouble is: the ID = 10 is not there. So why the formula failed to give a complete ranking order?
Please Login or Register to view this content.
Many thanks.
hi there. you have a value 1 in column A, so number 0.8 have 10 numbers greater than itself despite not having a value in column B. if it is supposed to ignore that and assuming column B always greater than 0, maybe:
Formula:
Please Login or Register to view this content.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Many thanks, benishiryo. It worked perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks