How to setup this Function?

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

Guest

I am needing a function that will look at the following and using 'max & if'
ID the highest salesperson.

George $300
Rita $400
Robert $500

It would be somelike this this: =IF(sales for #1=max,"salesperson #1
name",if(sales for #2=max,"salesperson #2 name", if......

but I'm not able to get it to work. Any suggestions?
 
=OFFSET(person1,MATCH(MAX(sales_data),sales_data,0)-1,0)

Where person1 is the cell that contains "George" in your example, and
sales_data is the range of all sales totals.

Jerry
 
=INDEX(A2:A50,MATCH(MAX(B2:B50),B2:B50,0))

replace A2:A50 with the sales people range and B2:B50 with their sales
amount
 
Back
Top