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...