Try this array formula** :

=MAX(IF(A$1:A$100=E1,B$1:B$100))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

Copy down as needed.

--
Biff
Microsoft Excel MVP


"GoBow777" wrote in message
...

Hello all:

Using Excel 2003

I have two lists, column A contains a list of names that have
reoccurrences of the same name many times within the list and I've
already made a list in column E of those unique names. Column B is a
list of numbers in random order and no two numbers are the same.

My problem is trying to make a new list in column F by finding the MAX
number in column B that is associated with the persons name in column
E.

I've tried many different formulas with no success, can any one please
help me out with this.




--
GoBow777