Solved Rank as 1st 2nd 3rd etc (POST 2)

February 13, 2015 at 04:39:31
Specs: Windows 7
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

See More: Rank as 1st 2nd 3rd etc (POST 2)

Report •

February 13, 2015 at 06:13:02
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.

Report •

February 13, 2015 at 07:00:37
✔ Best Answer
Once again, Google is your friend.

Modify the formula shown here, replacing each "A1" with your RANK formula.

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

Report •

February 13, 2015 at 11:58:39
Like DD said. :)

Report •

Related Solutions

Ask Question