| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adavanced filter?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit the number of rows for a filter | Excel Discussion (Misc queries) | |||
| Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
| Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
| Pivot table and filter | New Users to Excel | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Threaded Mode
