Look at the RANK function in help.

--
HTH

Bob Phillips

"Dave Jarvis" wrote in message
...
I have a spreadsheet which I get from the office which shows sales for
products in quantity and value against salespeoples names in a column, I
need
a function which will look at the list and automatically rank them
(obviously
highest first) in another column slightly to the right of the original
figures.