locating and deleting duplicate cell entries

J

John

I've developed a list of my Karaoke Song collection in Excel and I would like
to be able to locate duplicate Song Titles and have the option to delete the
entire row in which duplicates are located. I would not know in advance
which Song Titles have duplicates so a simple find function won't work for
me. Also, there would natrually be a lot of duplicate entries for "In the
Sytle Of" that I would not want to delete.
My spreadsheet looks like the following:
Col A Col B Col C
Song # Song Title In The Style of

With information in the succeding rows.

I'd prefer a Macro but an open to alternative soluntion. Can anyone help.
please?

Thanks, John
 
D

Don Guillett

I don't understand all of your question but if you sort and use a macro from
the bottom up will do it

sub deldups
mc = 2' col B
for i=cells(rows.count,mc).end(xlup).row to 1 step -1
if cells(i-1,mc)=cells(i,mc)then rows(i).delete
next i
end sub
 

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

Top