One method if pre-sorted on Artist's name.........

I C1 enter =A1

In C2 enter =IF(A2=A1,"",A2)

Double-click on fill handle to copy down.

Copypaste specialValuesOKEsc

Cut that column and paste to column A


Gord Dibben Excel MVP

On Tue, 6 Dec 2005 17:34:09 -0600, karyoker
wrote:


I have a spreadsheet with about 13,000 song entries... Col a artist col
b song title.. Iv'e read advanced filter tutorials till I'm blue in the
face.. All I want to is filter the artist column delete duplicates and
replace the dups with empty cells., Anything I try deletes the whole
row which deletes that song....

Artist .......... ............. Title

Neil Diamond .......... Brother Loves ....
Empty cel................ Holly Holy



Advanced filter or macro??????