combining unique values

[joldfield101]

Part 1

I would like to take info in a column and get a list of unique values

eg:

tom
dave
bob
dave
dave
tom
tom
dave
tom
bob


WOULD BECOME:

tom
dave
bob

NOTE: the data is contained on SHEET1 and i will have the formula on SHEET2

PART 2

I would like to sum up the values in column B for each name

eg:

tom	5
dave	6
bob	1
tom	5
dave	3
dave	3
bob	13

<tbody>
</tbody>

would become:

tom	10
dave	12
bob	14

<tbody>
</tbody>

NOTE: Again, the data is on SHEET1 and the formula is on SHEET2

 

[Aladin Akyurek]

Sheet2

A2, control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX(Sheet1!$A$2:$A$11,SMALL(IF(FREQUENCY(IF(Sheet1!$A$2:$A$11<>"",
   MATCH(Sheet1!$A$2:$A$11,Sheet1!$A$2:$A$11,0)),
   ROW(Sheet1!$A$2:$A$11)-ROW(Sheet1!$A$2)+1),
   ROW(Sheet1!$A$2:$A$11)-ROW(Sheet1!$A$2)+1),
   ROWS($A$2:A2))),"")

B2, just enter and copy down:

=IF($A2="","",SUMIF(Sheet1!$A$2:$A$1,$A2,Sheet1!$B$2:$B$11))