Excel Duplications

K

Ket.Kana

Hello All,

I have an excel spreadsheet that is being used as a contact database.
Column A contains Names, Column B contains addresses. The other columns
contain miscellaneous information.
Over time, the contacts in Column A have duplicated. Is there an easy way
of searching for all duplicate entries in column A and deleting the
duplicate row?
I am using Excel 2000 on Windows 2000.
Any help is greatly appreciated.

TIA

Ket
London, UK
 

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

Finding Duplicate Rows & Highlighting them 6
Duplicate entry in a column/row 14
Delete rows that contain duplicates 1
Duplication 2
Trying to count based on multiple criteria & cell comparisons 4
finding duplicate addresses across 2 worksheets in the same workbo 2
Formating bolded text exclusively. 0
error in highlighting duplicate values in excel 1

Top