formula convert results to 1st, 2nd, 3rd

Microsoft Excel 2003 (full product)
May 25, 2010 at 04:48:23
Specs: Windows XP
I am doing a spreadsheet to work out results from a range of tests. So column 1 to 4 will be results per test, total in column 5 ... but I want column 6 to read out of 20 participants (rows) whether they are 1st, 2nd or 3rd.
Can you help, please?

See More: formula convert results to 1st, 2nd, 3rd

Report •


#1
May 25, 2010 at 06:43:38
Look at the RANK and LARGE functions in Excel Help.

One of them should suit your needs.

Come on back if you have any questions about the use of those functions.


Report •
Related Solutions


Ask Question