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

"Gary" wrote:

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?

=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

--
Regards,

Peo Sjoblom


"Gary" wrote in message
...
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?

Hi Gary

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

--
Regards

Roger Govier


"Gary" wrote in message
...
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?

Thank you all for ur help, g

"Roger Govier" wrote:

Hi Gary

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

--
Regards

Roger Govier


"Gary" wrote in message
...
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?