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.