Forum Discussion
Displaying 1st, 2nd, 3rd.......nth.
Hi there. I use this rank formula to get the individual to get rank the performance of students as 1st, 2nd,3rd etc. which I will later match using index match function. The issue is that the ...
This formula would cover you from positions 1-20. I kept your original formula and added the ordinal.
=LET(position,INDEX($A$2:$M$7,MATCH($H$12,$A$2:$A$7,0),MATCH(D24,$A$2:$M$2,0)),position&VLOOKUP(position,{1,"st";2,"nd";3,"rd";4,"th"},2))