this is an ARRAY formula so must be edited/entered with ctrl+shift+enter
instead of just enter.

=MAX(IF(C4:C8="b",D4:D8))

--
Don Guillett
SalesAid Software

"LRATLARSON" wrote in message
...
How can I find the max in each group? The amount of data in each group
can
vary. An example is shown below:

Group Value
A 8
A 7
B 3
B 4
B 2