masud8956
Board Regular
- Joined
- Oct 22, 2016
- Messages
- 163
- Office Version
- 2016
- 2011
- 2007
- Platform
- Windows
Hi everyone!
I am using the following formula to rank 20 rows of entries at S5:S24.
What modification do I need to get the texts st, nd, rd, th as ordinal suffix?
Regards
I am using the following formula to rank 20 rows of entries at S5:S24.
Code:
=IF(ISNUMBER(R5),1+COUNTIF($R$5:$R$24,">"&R5),"")
What modification do I need to get the texts st, nd, rd, th as ordinal suffix?
Regards