.. All I want to is filter the artist column delete duplicates and
replace the dups with empty cells.,
Focusing on the above line ..
perhaps it'll be ideal to use a pivot table (PT) here
(only a few clicks will get us there ..)
Sample construct available at:
http://cjoint.com/?mhegGPvYQp
PivotTable_Approach_karyoker_newusers.xls
Assume the source table is in Sheet1,
cols A & B, data from row2 down:
Artist Title
Neil Diamond Title1
Tom Jones Title2
Neil Diamond Title3
Tom Jones Title4
John Lennon Title5
Neil Diamond Title6
John Lennon Title7
Tom Jones Title8
etc
Select any cell within the table
Click Data Pivot Table Report
Click Next Next
In step3 of the wiz.:
Drag and drop "Artist" within the ROW area
Drag and drop "Title" within the ROW area, below "Artist"
Drag and drop "Title" within the DATA area
(It'll appear as "Count of Title")
Click Finish
The PT will be created in a new sheet just to the left of Sheet1,
giving the summary format that is desired, viz.:
Each Artist will appear once only in col A,
with the artists' titles listed in col B
And if we don't want the Artists' subtotal lines,
in the PT sheet, just:
Double-click on "Artist", then select "None" for subtotals OK
(then just hide away col C and the "Grand Total" row for a neat look)
To quickly dress up a PT, just select any cell within the PT,
then click Format Autoformat
(select one of the table formats, play around to taste)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"karyoker" wrote in
message ...
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