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

J

JaneF

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.
 
J

Jim Thomlinson

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