Duplicate company name to be deleted

M

Mat

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
 
T

Terry Tipsy

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.
 
M

Mat

Dear Tipsy,

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

Regards

Mat
 
Top