I'm working on a very large set of data which often lists individuals multiple times. I would like to make a separate sheet that gives a general overview of the data, with each individual listed only once in the first column, with other columns giving sums of various pieces of data listed line by line on the original sheet.

EM Sample Book.xlsx

Is there a way to automatically take the contents of column A and have Excel spit out a list of all names where each is listed only once?

Thanks.