Managing Text Lists

  • Thread starter Thread starter Fitzy_bhoy
  • Start date Start date
F

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 said:
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"
Click to expand...
Cheers This is exactly what I wanted.

John
 
Back
Top