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
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