Now this is a nice one for the real MC-nerds (I guess) ;-)
This is the situation:
- I've got 300 files that were hits in 2005
- I imported them in MC
- I've got an Excel-sheet of the year-list of 2005 (The greatest hit is no. 1 and the worst one number 300)
- I want to sort my MC 2005 playlist in this this year-list order
I figured I could try doin' it something like this:
- make an extra column in Excel in which I put all the numbers 1 through 300
- sort my Excel-sheet alphabetically
- export my MC 2005 playlist to .txt-format
- open this playlist with Excel
- copy the 'numbers'-column from the original Excel-sheet
- paste this column in the MC-excel-sheet (in a special column that was originally, say, the BPM-field)
But then what?
I'd like to import my original MC-list back again, but this time with the BPM-column filled with the 1-300 numbers. Then I'd just have to sort in on 'BPM' and my list would be just like the real 2005-list is.
But how do I do this?
Can I do it in this way or is there another way?
(And I do know I can sort the list one by one in MC, but that's just what I don't want to do to save me from RSI).
Thanks for thinking with me!