Duplicate company name to be deleted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear Friends,

I have a column with 2000 company names (Row 1 to Row 2000), which includes
duplicates. I need to delete the duplicate names and keep only one unique
name in the column.

Regards

Mat
 
A simple solution would be to first sort the company names ascending then
insert an 'If' formula in another column to indicate if the the company name
is a duplicate, or is unique, such as =IF(A2=A1,"Duplicate","Unique"). This
formula is based on the assumption your data has a heading above the first
company name and the name is in cell A2.
 
Dear Tipsy,

Thanx a ton. The formula helped me to save time and energy. Keep up the good
work.

Regards

Mat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicates Deletion ? 2
Dupilicate entries amount to be added 5
Find duplicates in address register 2
Identifying duplicate rows 2
Delete Duplicate codes in a cell 1
Find Duplicate names and delate 4
Delete duplicate and original row 3
remove duplicates but retain one not delete both 4

Back
Top