Managing Text Lists

[Fitzy_bhoy]

I am trying to manage my mp3 files which are scattered over various cd's and
folders on my hd. I have decided to use the dir command in each folder to
make a seperate txt file. My plan is to import all of these into an excel
file. This I am confident of doing however, I would like excel to detect any
double entries of the same song, is there anyway to tell the program to
automatically flag any entries that are identical.

Thanks
John

 

[Gord Dibben]

John

Import the *.txt files into Excel one after another onto same worksheet.

You can use Data>Filter>Advanced Filter.

"Copy to a new location" and "Unique records only"

Filtering Tutorial at Debra Dalgleish's site.......
http://www.contextures.on.ca/tiptech.html

More on Duplicates marking, preventing at Chip Pearson's site....
http://www.cpearson.com/excel/topic.htm

Scroll down to "D" section and select Duplicate topics.

Gord Dibben Excel MVP

 

[Fitzy_bhoy]

John

Import the *.txt files into Excel one after another onto same worksheet.

You can use Data>Filter>Advanced Filter.

"Copy to a new location" and "Unique records only"

Cheers This is exactly what I wanted.

John