Set message subject here ...
in [General]
|
From: Dave Peterson on 24 May 2010 07:50 If you've ripped the cd to your harddrive and you used a track number in the title of the track, you may want to look at John Walkenbach's MP3 file lister workbook: http://spreadsheetpage.com/index.php/blog/mp3_file_lister_posted/ Cal wrote: > > I use excel to store my audio cd information, i have a big collection of music cds > > I have it like > > Column A = Currently blank > Column B = Artist > Column C = Track > Column D = Cd Name > > Then say a cd as 10 tracks then it will be 10 Rows containing artist, track name, cd name etc. > > What i would like if it is possible so far i do it manually but would like it easier etc. > > Where i drag down column A and it will automatically number each cd for me, it would be similar to this... > > 0001 / Prince / Alphabet Street / Greatest Hits > 0001 / Prince / 1999 / Greatest Hits > 0002 / Madonna /Vogue/Greatest Hits 2 > 0002 / Madonna /True Blue/Greatest Hits 2 > > So the number is the same for each track on that cd but changes when it`s a different cd. > > Is this possible? > > -- > --------------------------------- --- -- - > Posted with NewsLeecher v3.9 Final > Web @ http://www.newsleecher.com/?usenet > ------------------- ----- ---- -- - -- Dave Peterson
From: Luke M on 24 May 2010 08:48
Assuming your info is sorted by artist and CD name: =IF(AND(B2=B1,D2=D1),A1,A1+1) -- Best Regards, Luke M "Cal" <NOREPLY(a)HOTMAIL.COM> wrote in message news:4bfa3baf$0$21713$c3e8da3(a)news.astraweb.com... >I use excel to store my audio cd information, i have a big collection of >music cds > > I have it like > > Column A = Currently blank > Column B = Artist > Column C = Track > Column D = Cd Name > > > Then say a cd as 10 tracks then it will be 10 Rows containing artist, > track name, cd name etc. > > > What i would like if it is possible so far i do it manually but would like > it easier etc. > > Where i drag down column A and it will automatically number each cd for > me, it would be similar to this... > > > > 0001 / Prince / Alphabet Street / Greatest Hits > 0001 / Prince / 1999 / Greatest Hits > 0002 / Madonna /Vogue/Greatest Hits 2 > 0002 / Madonna /True Blue/Greatest Hits 2 > > > > So the number is the same for each track on that cd but changes when it`s > a different cd. > > Is this possible? > > > > > > -- > --------------------------------- --- -- - > Posted with NewsLeecher v3.9 Final > Web @ http://www.newsleecher.com/?usenet > ------------------- ----- ---- -- - > |