Finding state that contains employees biggest sale

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding state that contains employees biggest sale 7
Need subtotals 12
How to find similar records? 8
Change of Department 4
can you look up info from a validated drop down menu in excel 2007 1
Things for sale 8
Various stuff for sale 14
Formulas, Please help!!! 2

Back
Top