Excel help please guys.

[Colbaker]

Hi all.

I would like to pick your excel minds please.

Picture this. Column A has a list of names, these names could change at any time in a month. In Column B is how much money said person in Column A is Paid. These names will come up multiple times as there people will work multiple day.

Now what I am looking for on book 2 is a formula that in Column A will list all the names in book 1 but only once (not sure what formula could do this).
In Column B book 2 I want the amount of total money they have earned from Column B book 1 but only for each individual.

Any ideas on what formulas I should use? I hope I have made it clear

Thanks.

 

[Colbaker]

Thanks all for your reply's but i am really looking for formula's as they will be on a template, My boss wants to do as little as possible to get the information, formula's will do this automatically (hopefully).