Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup Problem
Hello,
I need some help with a lookup formula. In my data set, I have some customers shown multiple times - and I don't want to delete multiple listings in my data. I also have a column looking at the data and I want my formula to return the maximum amount for a particular customer. Example: Customer (A1) Sales (B1) Max Cust Value - lookup formula (C1) Microsoft $0 $200 Intel $10 $20 Microsoft $100 $200 Intel $20 $20 Microsoft $75 $200 Microsoft $200 $200 Formula result I'm looking for: In cell C2, I want a formula that would look at all the Microsoft values and return the maximum value which in this case would be $200. Similarly, I'd want cell C3 to return $20 for the max Intel value. Thanks in advance for your help. -Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Problem | Excel Worksheet Functions | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup Problem | Excel Worksheet Functions | |||
HELP -- probably a LOOKUP problem | Excel Discussion (Misc queries) | |||
Problem with LOOKUP & VLOOKUP | Excel Worksheet Functions |