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.

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.