Consolidating List

[bsb2013]

Given a list of names with repeats in column A and dollar values in column B, is there a way to create a list in C with each name stated only once(get rid of the repeats) and have the total dollar amounts in D for each name?

 

[Trevor G]

Consider this. Use a sort on the data into the named order you want, then look to use Sub Totalling this will give you the answer you want as you will see 1, 2, 3 as buttons next to Column Letter A then you select the 2 and you will see the totals.

 

[bsb2013]

what if i have a list of names in column A and a list of their job in column B, and I want to make a pie chart showing how many people have each type of job?

 

[bsb2013]

So I could use a sort then a countIf if I knew which jobs I was looking for, but I don't know which jobs... I want to count how many of every job

 

[snoopyhr]

for the first question to extract unique list from the multiple name list check this video, first 10 miniutes explains how to do this and the rest will show you how to utilize this as data validation list.

http://www.youtube.com/watch?v=IhuURsu0jdI