Duplicate Name List

  • Thread starter Thread starter kurios
  • Start date Start date
K

kurios

I have a large file, some 3000+ lines with account names,
of these most are duplicated, at the most there are only
around 70 individual names. How can I produce a list with
just one line for each name.
 
Hi

1- Search help for advanced filter.

or

2- arrange the accounts in ascending order. If ur data starts from cell
A1, then in B1 write this formula "=A1=A2". Drag this formula down to
the last account. Apply auto filter and delete all records that are
TRUE.

there might be other ways of doing this but these are the quickest.

Regards
Asim
 
Use data|filter|advanced filter with the unique records
only box checked on your column

Allen
 
Back
Top