locating and deleting duplicate cell entries
 

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


--
John

locating and deleting duplicate cell entries
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"John" wrote in message
...
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


--
John

locating and deleting duplicate cell entries
 

Hi,
Look into CPearson web go to Delete Duplicate rows about the middle of the
page

http://www.cpearson.com/excel/deleting.htm

if this helps please click yes thanks



"John" wrote:

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


--
John