# Who wins your iTunes? **URL:** \ **Category:** Cafe Society\ **Created:** [June 23, 2008, 4:01am UTC](https://boards.straightdope.com/t/who-wins-your-itunes/453880 "2008-06-23T04:01:05Z")\ **Posts on this page:** 9\ **Page:** 4
**Author:** ![woodstockbirdybird](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/woodstockbirdybird/32/7905_2.png) [@woodstockbirdybird](https://boards.straightdope.com/u/woodstockbirdybird)\ **Post date:** [June 24, 2008, 10:43pm UTC](https://boards.straightdope.com/t/who-wins-your-itunes/453880/61 "2008-06-24T22:43:08Z")
[QUOTE=capybara] And judging by your list you are exactly. . . 39 years old? Between 38 and 42? ETA: and by the way, what’s your Simplify Media or Mojo username ?! (har) [/QUOTE] 38 as of last month. Good show! My Simplify Media name is “mailroommusic” (Or mail room music - I don’t remember if there are spaces), but I only use it at work, where I use a smaller (160GB) external hard drive, so there are no bootlegs on it. There are still about 40,000 songs, though, so if you want to add me, be my guest. ---
**Author:** ![JimOfAllTrades](https://avatars.discourse-cdn.com/v4/letter/j/ba8739/32.png) [@JimOfAllTrades](https://boards.straightdope.com/u/JimOfAllTrades)\ **Post date:** [June 25, 2008, 3:41am UTC](https://boards.straightdope.com/t/who-wins-your-itunes/453880/62 "2008-06-25T03:41:33Z")
Out of a little over 2000 tracks, about half are represented by the top 20 artists: Ray Charles - 161 Pink Floyd - 77 The Moody Blues - 71 Cream - 63 The Beatles - 60 Simon & Garfunkel - 58 The Doors - 53 Neil Diamond - 52 Stevie Ray Vaughan - 46 Bobby Darin - 44 Solomon Burke - 31 The Three Tenors - 30 U2 - 28 Blues Traveler - 25 Eric Clapton - 25 Queen - 25 Rod Stewart - 25 Rusted Root - 25 The Eagles - 25 AC/DC - 24 Interesting, I’ve got a six way tie going on at 14 through 19. ---
**Author:** ![Acsenray](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/acsenray/32/4519_2.png) [@Acsenray](https://boards.straightdope.com/u/Acsenray)\ **Post date:** [July 3, 2008, 9:50pm UTC](https://boards.straightdope.com/t/who-wins-your-itunes/453880/63 "2008-07-03T21:50:50Z")
[QUOTE=Boyo Jim] I export the list to a text file, paste the list into Excel, do Subtotals by Artist, and then sort in descending order. [/QUOTE] Okay, I’ve imported the list into Excel. What do I do now? Highlight the “artists” column? ---
**Author:** ![Boyo\_Jim](https://avatars.discourse-cdn.com/v4/letter/b/87869e/32.png) [@Boyo\_Jim](https://boards.straightdope.com/u/Boyo_Jim)\ **Post date:** [July 3, 2008, 11:44pm UTC](https://boards.straightdope.com/t/who-wins-your-itunes/453880/64 "2008-07-03T23:44:57Z")
[QUOTE=acsenray] Okay, I’ve imported the list into Excel. What do I do now? Highlight the “artists” column? [/QUOTE] See post #43 ---
**Author:** ![St.Urho](https://avatars.discourse-cdn.com/v4/letter/s/8e7dd6/32.png) [@St.Urho](https://boards.straightdope.com/u/St.Urho)\ **Post date:** [July 4, 2008, 12:22am UTC](https://boards.straightdope.com/t/who-wins-your-itunes/453880/65 "2008-07-04T00:22:38Z")
Out of 1995 songs: 1. 222- Bruce Springsteen 2. 66- Me First & The Gimme Gimmes 3. 61- Morphine 4. 52- The Pogues 5. 46- barenaked ladies ---
**Author:** ![DfrntBreign](https://avatars.discourse-cdn.com/v4/letter/d/f6c823/32.png) [@DfrntBreign](https://boards.straightdope.com/u/DfrntBreign)\ **Post date:** [July 4, 2008, 7:40am UTC](https://boards.straightdope.com/t/who-wins-your-itunes/453880/66 "2008-07-04T07:40:58Z")
From 6248 songs: Santana - 279 Widespread Panic - 194 Allman Brothers Band - 132 Pink Floyd - 100 Jimi Hendrix - 93 (pretty good for a guy who put out four albums, hunh?) moe. - 86 Rush - 85 Yes - 82 Led Zepplin - 77 Steely Dan - 77 Gov’t Mule - 75 Dave Matthews Band - 72 Little Feat - 66 Zappa - 59 String Cheese Incident - 58 The jambands are probably a little more heavily represented than they should be. What can I say, Widespread Panic has made more records than Return To Forever. ---
**Author:** ![Acsenray](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/acsenray/32/4519_2.png) [@Acsenray](https://boards.straightdope.com/u/Acsenray)\ **Post date:** [July 4, 2008, 2:44pm UTC](https://boards.straightdope.com/t/who-wins-your-itunes/453880/67 "2008-07-04T14:44:14Z")
[QUOTE=Boyo Jim] 6. If you care to sort the list of artists by count, select the whole grid, Press “CTRL G”, press the “Special” button, and the “Visible Cells Only” radio button. Copy this into a blank worksheet, and then sort by column B. [/QUOTE] What’s the menu or Apple translation for “Ctrl G”? ---
**Author:** ![Boyo\_Jim](https://avatars.discourse-cdn.com/v4/letter/b/87869e/32.png) [@Boyo\_Jim](https://boards.straightdope.com/u/Boyo_Jim)\ **Post date:** [July 4, 2008, 3:28pm UTC](https://boards.straightdope.com/t/who-wins-your-itunes/453880/68 "2008-07-04T15:28:46Z")
[QUOTE=acsenray] What’s the menu or Apple translation for “Ctrl G”? [/QUOTE] I’m not sure, but in the PC version, under the edit menu you select “Go To”, if that helps. ---
**Author:** ![Acsenray](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/acsenray/32/4519_2.png) [@Acsenray](https://boards.straightdope.com/u/Acsenray)\ **Post date:** [July 4, 2008, 3:40pm UTC](https://boards.straightdope.com/t/who-wins-your-itunes/453880/69 "2008-07-04T15:40:30Z")
That did it! [Previous page](https://boards.straightdope.com/t/who-wins-your-itunes/453880.md?page=3)