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
 
You must log in or register to reply here.

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
Deleting Duplicates in Excel - Databases 1
number alpha list w/duplications 4
Excel Subtotal without calculate duplicate lines 4
Count how many different cells are in a range 1
Marking duplicate entries based on multiple columns 5
Identify Duplicates in a List 1
is there a simple formula that will remove all duplicates in a simple list 1

Back
Top