# Thread: Calculate Highest Number

1. Column 1 contains a list of names, and column 2 calculates the number of lunches that person attended. I know that I can use the MAX function on column 2 to determine the highest number in the lunches column, but how do I determine the name of the person who matches the MAX number?

I am using Excel 2000/SP-3

Thanks for your help.

2. The attached example should solve your dilemma. Note that there may be more than one person with the most. Also note that in rows 2:6, columns E:G have the same formulae; Row 1 is unique.

[attachment=83268:Most_Lunches.xls]

3. [quote name='wdwells' post='769772' date='08-Apr-2009 11:22']The attached example should solve your dilemma. Note that there may be more than one person with the most. Also note that in rows 2:6, columns E:G have the same formulae; Row 1 is unique.[/quote]

Thank you for your help! I'll give a try.

4. An easier formula is to use:

=LOOKUP(MAX(B2:B100),B2:B100,A2:A100)

Assuming the list of diners is in range A2:A100. Adjust to fit

5. [quote name='Jezza' post='769817' date='08-Apr-2009 18:36']An easier formula is to use:

=LOOKUP(MAX(B2:B100),B2:B100,A2:A100)

Assuming the list of diners is in range A2:A100. Adjust to fit[/quote]

I don't think that approach will work in this instance. Note the following from LOOKUP Help

Important The values in lookup_vector must be placed in ascending order: ...,-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP may not give the correct value. Uppercase and lowercase text are equivalent.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•