Wednesday, September 30, 2015

Finding unique values in a column



Source:

http://www.get-digital-help.com/2009/03/30/how-to-extract-a-unique-list-and-the-duplicates-in-excel-from-one-column/

This site has variety of methods to extract unique values from a column. But I have not used the formula but use advanced feature in excel(even that technique is method in this website).



Solution1: You could select the data and go to Data -> Remove Duplicates.

No comments:

Post a Comment