I'm sure this is an easy one for all the experts, but I'm just learning
this stuff and have racked my brains and can't figure out an easy
way....

On Sheet 1, Column B I have up to 200 names ("B1:B200"), many name
repeats.
also on sheet 1, Column E, I have earnings ("E1:E200") beside their
names

What I need to do is:

On Sheet 2: copy the individual names (just once) and add all their
earnings together for a total earned.

Thanks in advance for the help

Buddy :)


--
BuddyB
------------------------------------------------------------------------
BuddyB's Profile: http://www.excelforum.com/member.php...o&userid=17694
View this thread: http://www.excelforum.com/showthread...hreadid=345757