• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula to look up Rank

E

Ecel Dumbo

Member
Hello Friends,


Please refer the attached worksheet and advise how to rank items (rank 1 to 7 only) in

ascending/descending order.


http://speedy.sh/Jsr7C/Formula-to-look-up-Ranks.xls


Thanks

Dumbo
 
Hello,


Sorry please ignore the first file. Do refer the attached file


http://speedy.sh/94ax7/Formula-to-look-up-Ranks-new.xls


Sorry for the inconvenience caused
 
D3 = =IFERROR(INDEX($D$20:$D$26,MATCH(C3,$C$20:$C$26,-1)),7)

G3 = =RANK(F3,$F$3:$F$8,1)

J3 = =RANK(I3,$F$3:$F$8,1)

M3 = =IFERROR(INDEX($L$20:$M$26,MATCH(L3,$L$20:$L$26,-1),2),7)


Remove the + signs from table...
 
Hi Indian, Thanks for your valuable time


I did not get it right


For the first formula I was getting a name# error.


For the second , it worked, but I would like to keep the rank till 7. Suppose there are 8 items to rank, the 8th smallest item will not get any rank, there will only be ranks from 1 to 7


Please see attached file


http://speedy.sh/7fset/Formula-to-look-up-Ranks-new-2.xls
 
You must log in or register to reply here.
Back
Top