How can I find the max in each group?

[LRATLARSON]

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

 

[JE McGimpsey]

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.

 

[Frank Kabel]

Hi
try for example the following array formula (entered with
cTRL+SHIFT+ENTER):
=MAX(IF(A1:A100="A",B1:B100))

also check out pivot tables:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm

 

[Don Guillett]

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

=MAX(IF(C4:C8="b",D48))

 

[Aladin Akyurek]

D2:

=MAX(IF($A$2:$A$6=C2,$B$2:$B$6))

which must be confirmed with control+shift+enter instead of just wit
enter.

Note that C2 houses a group id like A.

Another option is to build a pivot table from the data.