how to display 1st, 2nd, 3rd referring to rank
Hello
Iv'e created a ranking but cannot display 1st, 2nd, 3rd with duplicates
the cell should refer to a ranking.
Do I have to use if statement?
attached is the sample pls. look at sheet(over-all ranking )
Please Login or Register to view this content.
thanks in advance
Last edited by vlady; 10-02-2011 at 10:15 PM.
Enter this in O14 and copy down.
=IF(N14=1,"1st Honors",IF(N14=2,"2nd Honors",IF(N14=3,"3rd Honors","Comendable")))
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
thank for your quick reply.
it works.
but another one can i put that code to a ranking code, this is the code. how??
=RANK(M14,M$14:M$61,1)+(COUNTIF(M$14:M$61,M14)-1)/2
thanks
Sure in O14 repalce the three N14's with your rank formula minus the "=" sign.
ok. thanks that did it.
by the way if there is a duplicate rank with decimals like there are ranks so the rank will be
1.5
1.5
2.5
2.5
and so on from the formula you've given
i'll just change 1 to 1.5 ?=IF(N14=1,"1st Honors",IF(N14=2,"2nd Honors",IF(N14=3,"3rd Honors","Commendable")))
can you give me some advice.
ok. thanks that did it.
by the way if there is a duplicate rank with decimals like there are ranks so the rank will be
1.5
1.5
2.5
2.5
and so on from the formula you've given
i'll just change 1 to 1.5 ?=IF(N14=1,"1st Honors",IF(N14=2,"2nd Honors",IF(N14=3,"3rd Honors","Commendable")))
can you give me some advice.
Depends on how you want your result. If 1.5 is still 1st Honors then instead of =1 do less than <1.9.HTH
thanks that did it....
more power...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks