help

  • Thread starter Thread starter wallybiscotti
  • Start date Start date
W

wallybiscotti

Is there a function in Excel that goes through a column and delete's al
of the double entries.

For example, I have a list of 1600 people. Some of them work for th
same company and some don't. I only need one name from each business
Is it possible to search down the business name column and delete al
the doubles??

thank yo
 
No there isn't. However you can create a new list with any given name only
appearing once.

e.g. your list
Smith
Smith
Jones
Xi
Jones

New list:
Smith
Jones
Xi

Put the formula =IF(COUNTIF(A$1:A1,A1)>1,"",A1)
where A1 is the first cell in the list of names, then copy it down to the
last cell in the range. What will result is a new list with unique names.
You can then copy/paste special/values this list, and sort to compress the
list as it will contain spaces.
 
Back
Top