Duplicate deletion

[kpsony]

I need to know how to delete any of the cells that have duplicates.

Suppose I have a list of names, and I want to delete all the names that have duplicates in the list, so their compeltely out of this list... any help?

Thanks

 

[SkipVought]

Hi,

1) sort on the column(s) with the key values you want to determine duplicates.

2) enter this formula, assuming that column A has the key values you want to determine duplicates.

in the first empty column in ROW 2
[tt]
=if(a1=a2,1,0)
[/tt]
3) select the COLUMN containing the above formula and COPY. Edit/Paste Special - Values

4) Data/Autofilter - select 1

5) Select the ROWS containg the data (excluding any headings)

6) Right Click - Delete Rows

7) Data/AutoFilter - Show All

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[kpsony]

I want to find all the names that have duplicates and delete them all, even the originals, so there name is no longer in the list... any help?

 

[kpsony]

Suppose I have a list of Names of people who have donated to us. Then the MAIN list of EVERYONE in the DB (including the donors), I need to take the list of names of donors out of the MAIN list...

 

[SkipVought]

in row 2...
[tt]
=IF(OR(A1=A2,A2=A3),1,0)
[/tt]


Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[kpsony]

That code doesnt seem to be working... I have a list of #'s (donor IDs) and I have them in column A, and in Column B I copied that code to B1 and Copied it down the entire column... It's putting 1's next to soem that are not doubled...

 

[SkipVought]

Start in B2


Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}