One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=MAX(IF(A1:A100="A",B1:B1000))


Better:

Use a Pivot Table, with Group in the Rows field and Max of Value in the
Data field.


In article ,
"LRATLARSON" wrote:

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