+ 0 Votes Best use VB ThumbsUp2 4 years ago Excel itself, using just formulas, wouldn't do it for you. Best use a script to do the job. You would search through the list of names (column A) storing each 'unique' name in a variable array, then go through that array, one item at a time, searching the original list for a match and adding the contents of column B next to that name to a summation variable. After each loop through, print the name and the contents of the summation variable to another cell/sheet, reset the variables, move to the next unique name in the array and do it all over again. There's a little more to it than that, but you get the drift.