I have a function which ranks cells in a row from 1 to 36. How can i write the function to record as 1st, 2nd, 3rd etc to 36th

Hmmmm A little complicated. What are you using to determine the place number? If you've already determined the Place numbers (ranking), and the entries are not a result of formulas, you could do nested IF statements to display the correct Rank. If the numbers are absolute, it may just be faster to change the fields from the numbers to text.

Unless I'm misunderstanding your goal here.

Once again, Google is your friend. Modify the formula shown here, replacing each "A1" with your RANK formula.

http://www.cpearson.com/excel/Ordin...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Like DD said. :)

Ask Your Question

Weekly Poll