Board index » Help Help » Technical Support




Post new topic Reply to topic  [ 22 posts ]  Go to page Previous  1, 2
Author Message
 Post subject: Re: excel formulas
PostPosted: Thu Apr 01, 2010 10:28 am 
Offline
User avatar
Yeah Yeah Yeah
 Profile

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.


Top
 
 Post subject: Re: excel formulas
PostPosted: Thu Apr 01, 2010 10:36 am 
Offline
User avatar
Yeah Yeah Yeah
 Profile

Joined: Sat Oct 23, 2004 1:51 pm
Posts: 4329
Location: PA
If you're comfortable with nested if statements, I believe this would work:

=if(a9<=10000,0,if(a9<=14000,0.02,if(a9<=18000,0.03,if(a9<=22000,0.04,if(a9<=26000,0.06,0.07)))))

_________________
emanon wrote:
I think I either need to drink less to become more alert, or more so as not to care.


Top
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 22 posts ]  Go to page Previous  1, 2

Board index » Help Help » Technical Support


Who is online

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

Search for:
Jump to:  
cron
It is currently Mon Jun 17, 2024 8:43 am