Good day all,
Please in the attached file, I’m combining Rank and Right functions to see if I can add appropriate suffixes to my result. I want things like these:
1st
2nd
3rd
4th
5th
6th
7th
8th
9th
10th
11th
Etc.
Please any help will be appreciated for the formular I currently have gives me only “th”
you need to change the rank to text format , i suspect
=RIGHT(TEXT((RANK(A1,$A$1:$A$17,0)),0),1)
=RANK(A1,$A$1:$A$117,0)&IF(OR(RIGHT(TEXT((RANK(A1,$A$1:$A$117,0)),0),2)="11",RIGHT(TEXT((RANK(A1,$A$1:$A$117,0)),0),2)="12",RIGHT(TEXT((RANK(A1,$A$1:$A$117,0)),0),2)="13"),"th",IF(RIGHT(TEXT((RANK(A1,$A$1:$A$117,0)),0),1)="1","st",IF(RIGHT(TEXT((RANK(A1,$A$1:$A$117,0)),0),1)="2","nd",IF(RIGHT(TEXT((RANK(A1,$A$1:$A$117,0)),0),1)="3","rd","th"))))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks