Hello Everyone,
I have student's data in which column A contains Students name and Column B contains sales quantity. In Column D I want to retrieve the Students name rank wise in descending order.
For reference please find the attached file.
Thanks in advance
Ankit
Hi Ankit,
Please use this formula in cell D2:- =INDEX($A$2:$A$14,MATCH(LARGE($B$2:$B$14,ROW(D1:D1)),$B$2:$B$14,0))
Thanks
Nisha Dhawan
If you like my answer please click on * Add Reputation
"If you can dream it, You can do it"
How doo you want ties to treated? The above formula gives the same name twice if there is a tie
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi Glenn,
I want if tie is there then both name should come let's say if Bernie and Petra has scored 90 then it should come Bernie at 2nd rank and then Petra should come on 3rd rank.
Thanks
Ankit
OK. Try this, then. It does need a helper.
You are great, its perfect.
Thankyou Glenn
Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
=index($a$2:$a$14,match(large(index($b$2:$b$14+1/(row($b$2:$b$14)*10^5),0),row($a1)),index($b$2:$b$14+1/(row($b$2:$b$14)*10^5),0),0))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Dohh! I forgot about that approach.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks