What I usually do is in a new column put:

=IF(AND(A2=A1),"DUP","")

This only works if you are trying to compare a column with unique IDs.
However, if you're looking at a list of names where some names might be
duplicated (example: Two people named James, but one lives in USA and
the other lives in Germany) try something like this:

=IF(AND(A2=A1,B2=B1,C2=C1,D2=D1),"DUP","")

You're limited to 30 different ANDs... but that usually does the
trick.

...then copy/paste the formula down. This makes it much easier to
identify duplicates when you scroll down. And if you want to go a step
further:

You can then copy the new column and pastespecial (values) and then
re-sort the data by this new column in descending order. Delete the
duplicate rows then re-sort by your original column. This only checks
to see if the cell is equal to the one above it so it only works after
everything is sorted by your original sort column.

Probably easier to do it manually if you only have 20 or 30 records,
but it'd save you a lot of time if you have 100s or 1000s of them.

I hope that makes sense.


wrdennig Wrote:
I add records, daily, to a master file. Sometimes a record is a
duplicate.
At this point, I sort by one column and then scroll down looking for
duplicate records, which I delete. Is there an easier way? I don't
want to
have duplicate records.

THanks, Walt


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=534582