How to setup this Function?

G

Gary

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?
 
J

Jerry W. Lewis

=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
 
P

Peo Sjoblom

=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
 
R

Roger Govier

Hi Gary

With your data in columns A and B, try
=INDEX(A:A,MATCH(MAX(B:B),B:B,0))
 
Top