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

--
Regards
Frank Kabel
Frankfurt, Germany

"LRATLARSON" schrieb im
Newsbeitrag ...
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