| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding state that contains employees biggest sale
I have data like this
EMPLOYEE SALE STATE Joe 10.00 PA Joe 20.00 VA Sue 5.00 TX Sue 10.00 WA For each employee, how do I find the state that corresponds to the largest sale. For example, for Joe this would be VA since his largest sale of 20.00 was to VA. -- Richard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
| Finding a name with biggest number | Excel Worksheet Functions | |||
| If function with date; if sale is Oct place sale $ amount here | Excel Worksheet Functions | |||
| Would u help me with a Biggest Movers type of comparison? | Excel Discussion (Misc queries) | |||
| skus in columm a for each sale, qty. of skus sold, each sale in co | Excel Worksheet Functions | |||
Threaded Mode
