Joined: Sat Oct 23, 2004 1:51 pm Posts: 4329 Location: PA
dimejinky99 wrote:
Px are you any good at Excel? I dread it but i've compiled an excel spreadsheet of all my pj gigs attended under the assumption I could pull up how many Given to Flys I've seen for example, yet I can't figure that out on excel at all. Any ideas how?
I haaaate excel.
Put all the songs in one column and run a Pivot Table. I did that about a week ago. My stats:
1/2 Full 5 Alive 17 All NIght 4 Alone 1 Amongst The Waves 1 Animal 11 Army Reserve 2 Around The Bend 1 Baba O’Riley 5 Bee Girl 1 Better Man 16 Big Wave 1 Black 11 Black Diamond 1 Bleed For Me 3 Blood 8 Brain of J 5 Breakerfall 2 Breath 3 Bugs 1 Can’t Keep 2 Comatose 6 Come Back 2 Corduroy 15 Crazy Mary 11 Cropduster 4 Crown Of Thorns 2 Daughter 10 Deep 2 Dissident 3 Do the Evolution 18 Don’t Gimme No Lip 2 Down 4 Driven To Tears 1 Elderly Woman 13 Evacuation 1 Even Flow 19 Faithfull 3 Footsteps 2 Force Of Nature 1 Fortunate Son 2 Fuckin’ Up 1 Garden 7 Get Right 1 Gimme Some Truth 2 Given To Fly 14 Glorified G 4 Go 8 God’s Dice 2 Gone 5 Gonna See My Friend 1 Got Some 2 Green Disease 4 Grievance 5 Habit 3 Hail Hail 7 Hard to Imagine 3 Harvest Moon 3 Help Help 1 Hold On 1 I Am Mine 4 I Believe In Miracles 3 I Got Shit 5 I’m Open 3 Immortality 3 Improv 2 In Hiding 6 In My Tree 2 Indifference 1 Inside Job 5 Insignificance 7 Jeremy 9 Johnny Guitar 2 Just Breathe 3 Last Exit 9 Last Kiss 9 Leash 5 Leatherman 1 Leaving Here 5 Life Wasted 6 Light Years 2 Little Sister 1 Love Boat Captain 7 Love Reign O’er Me 1 Low Light 2 Lukin 6 Man of the Hour 2 Mankind 1 Marker in the Sand 4 Masters Of War 2 MFC 4 No More 2 No Way 1 Not For You 4 Nothing As It Seems 4 Nothingman 4 Of The Girl 1 Off He Goes 2 Once 3 Out Of My Mind 1 Parachutes 1 Parting Ways 1 Pilate 1 Porch 9 Present Tense 3 Push Me Pull Me 1 Rats 4 Rearviewmirror 10 Release 5 Rival 1 Rockin In The Free World 11 Sad 3 Satan’s Bed 3 Save You 7 Severed Hand 8 Sleight Of Hand 2 Smile 3 Sonic Reducer 2 Soon Forget 3 Speed of Sound 2 Spin The Black Circle 4 State Of Love And Trust 7 Sweet Lew 1 The American In Me 2 The End 1 The Fixer 3 The New World 1 The Real Me 1 Thin Air 1 Thumbing My Way 1 Tremor Christ 1 U 1 Unemployable 3 Unthought Known 2 Untitled 3 W.M.A. 1 Waiting on a Friend 1 Wash 3 Wasted Reprise 5 Whip It 1 Whipping 6 Who You Are 2 Why Go 8 Wishlist 5 World Wide Suicide 7 Yellow Ledbetter 17 You Are 3 You’ve Got To Hide Your Love Away 4 Total Result 615
_________________
emanon wrote:
I think I either need to drink less to become more alert, or more so as not to care.
Users browsing this forum: No registered users and 2 guests
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum