Writing Position
I want to write positions of students in this format
NAME: MARKS POSITION
Irfan 33 6
maqsood 54 5
rizwan 60 4
mazhar 99 1ST
saeed 25 7
rasheed 68 3RD
fareed 98 2ND
bashir 21 8
Using RANK(B1,B1:B9,0) it displays position 1,2,3 etc.. but i want the first three positions should be written as 1st, 2nd, 3rd and remaining position should be 4,5,6,7,8 etc..If anyone can help?
Try:
Formula:
=RANK($B2,$B$2:$B$9,0)&IFERROR(CHOOSE(RANK($B2,$B$2:$B$9,0),"st","nd","rd"),"")
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
or
=IF(RANK(B1,$B$1:$B$9,0)<4,CHOOSE(RANK(B1,$B$1:$B$9,0),"1st","2nd","3rd"),RANK(B1,$B$1:$B$9,0))
Last edited by kev_; 10-23-2017 at 06:17 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
or
=RANK($B2,$B$2:$B$9,0)&IFERROR(INDEX({"st","nd","rd"},RANK($B2,$B$2:$B$9,0)),"")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
or
=IFERROR(CHOOSE(RANK($B2,$B$2:$B$9,0),"1st","2nd","3rd"),RANK($B2,$B$2:$B$9,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Shoaib7832 
Register To Reply
Bookmarks