duplicates

  • Thread starter Thread starter bernadette
  • Start date Start date
B

bernadette

I need to know how to locate duplicate entries in a list
of cells.... if I have 150 email addresses, how do I
eliminate duplicate addresses?
 
Hi
another way: You may use 'Data - Filter - Advanced filters' to extract
unique entries

Frank
 
I face a slightly different problem with duplicates. I want to know how many unique records exist in the database. For example,

Dat
aaaa
aaaa
bbbb
bbbb
aaaa
ccccc

Is there a function in Excel that will return 3 i.e. three sets of unique data (aaaaa, bbbbb, ccccc)? I cannot use pivot table as it only returns the number of occurences for each. Your advice is appreciated. Thank you.
 
Back
Top