Max valve for each customer

S

syscan

Hello, I am the new member here and would like to seek your prof. help
in Excel. Thank you.

Given:

_A1:_Customer_
A2: JOE
A3: TOM
A4: JOE
A5: PETER
A6: JOE

_B1:_Purchase_
B2: $11
B3: $22
B4: $25
B5: $20
B6: $11.5

How can I have gotten the max pruchase for _each__ customer?

Let's say, Joe have total 3 records in the sheet (A2, A4 & A6) and the
purchase are $11 (B2), $25 (B4)& $11.5 (B6) respectively.

What I need is to sort out the max purchase value of JOE, i.e. $25.

Thanks all!
 
B

Bob Phillips

Sans pivot table.

=MAX(IF(A1:a100="JOE",B1:B100))

which is an array formula, so commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
S

syscan

YEAH! I can do it via your suggestions.
Thank you very much! Paul Sheppard & Bob Phillips
 
Top