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