Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate company name to be deleted
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate company name to be deleted
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. -- T Tipsy "Mat" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate company name to be deleted
Dear Tipsy,
Thanx a ton. The formula helped me to save time and energy. Keep up the good work. Regards Mat "Mat" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate company name to be deleted
Dear Terry,
Sorry to address you by last name. Regards Mat "Mat" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
Is there a way MATCH() can cope with duplicate values? | Excel Worksheet Functions | |||
IF formula with MAX function | Excel Discussion (Misc queries) | |||
How to find duplicate data in two tables,then listing it?(Excel) | Excel Worksheet Functions | |||
Help with Formula | Excel Worksheet Functions |