D2:

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

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

Note that C2 houses a group id like A.

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

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


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=319760