Filters only work on entire rows, so that doesn't seem like the path you want.
Are you just trying to clean it up visually, so it appears less cluttered?
If so, I'd suggest conditional formatting, setting it up so that a repeated
artist is IN the cell, but not shown. Then if the table gets shuffled
(sorted, whatever), the artist will be there. To set up the conditional
format, go to A2. Format Conditional Formatting. Use the drop-downs to
set the condition to be 'cell value is' 'equal to' =A1. Click the format
button and set it up so that the font color is white. Click OK. Copy that
cell, highlight the rest of the column and Edit Paste Special, select
Formats and click OK.
Now if an artist is repeated in consecutive rows, only the first will be
visible. Other rows contain the artist name, but it's masked by the white
font on a white background. And if the table gets sorted, the artist name
will appear as long as it doesn't repeat the prior cell.
HTH. --Bruce

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


--
karyoker
------------------------------------------------------------------------
karyoker's Profile: http://www.excelforum.com/member.php...o&userid=29417
View this thread: http://www.excelforum.com/showthread...hreadid=491284