How do I put data in excel in placing order? eg first, second, th.

[Guest]

I have created a spreadsheet for the different rounds of a quiz and I have
been asked to include a column which will show the placings as the quiz goes
on ie First, second, third etc. I am not sure how to go about this.

 

[Guest]

Take a looke at the Large function and the Rank function. Most likely you
want Rank...

 

[Guest]

Jim

Thanks for pointing me in the right direction