Hi all,
I've developed a sheet which works works out a competitors score in a competition, and their position in the contest (using the RANK function).
However this only displays their position as an integer number, i.e. "1" for the winner, "2" for the runner-up, etc. Is there any way I can format the range so their positions appear as 1st, 2nd, 3rd, 4th... etc?
I could use a lookup table to get this effect but I'm sure there must be another way to achieve this?
Thanks in advance!
Roy K.
Bookmarks