Sales League table
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. |
All times are GMT +1. The time now is 08:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com