Formula
 

Hello everyone. Was hoping for some formula help. With this abridged
sample data:

A 8
B 4
C 9
A 6
D 7
S 1
A 6

I conceptually would like excel to scan the first column (A), and identify
all A's, and return the Max of the value found in column B.

Formula
 

See Chip Pearson's reply to your same question with a better subject line:
http://google.com/groups?threadm=Odo...GP10.phx .gbl