Rank with ordinal suffix in Excel
To add an ordinal suffix to a number (i.e. 1st, 2nd, 3rd, etc.) you can use a formula based on the CHOOSE function to assign the suffix.
Covered this video:
how to type 1st, 2nd, 3rd in excel,excel date format 1st, 2nd, 3rd,google sheets ordinal numbers,how to 1st,how to write 2nd,ordinal date excel,addth excel,how to write st'',nd'',rd'',th in excel,ordinal format,ordinal format excel,vba ordinal numbers,conditional formatting 1st, 2nd 3rd,date 1st, 2nd, 3rd, 4th