User Pass
Home Sign Up Contact Log In
Forum > Goal Line Blitz > How many flex have you bought since starting GLB?
Page:
 
jdpbernal
offline
Link
 
almost 450K
Edited by jdpbernal on Jan 26, 2010 18:02:28
 
BADGERBACKER
offline
Link
 
A hair over 1.3M.
 
jdpbernal
offline
Link
 
Originally posted by BADGERBACKER
A hair over 1.3M.


damn! I still have lots of work to do to get to that number!
 
Ubasstards
offline
Link
 
Originally posted by tautology
Originally posted by Ubasstards

Originally posted by tautology


My flex point history is 4,412 lines long.



open microsoft excel
Highlight your flex point history
Copy
Paste Special into excel (Text)
Sort Data by column B
Highlight all next to "purchase" and read sum in bottom right of excel

20 seconds to answer IMO


ermm...how do you think I figured out how many lines there were? Did you think I counted them one by one?





Also: =sumproduct((A1:A4412="purchase")*(B1:B4412)) is my preferred method



that method adds 2-3 seconds time.

If you needs some excel tips, please PM me.
 
bug03
offline
Link
 
excel is greatest thing ever invented imo
 
tautology
offline
Link
 
Originally posted by Ubasstards
Originally posted by tautology

Originally posted by Ubasstards


Originally posted by tautology



My flex point history is 4,412 lines long.



open microsoft excel
Highlight your flex point history
Copy
Paste Special into excel (Text)
Sort Data by column B
Highlight all next to "purchase" and read sum in bottom right of excel

20 seconds to answer IMO


ermm...how do you think I figured out how many lines there were? Did you think I counted them one by one?





Also: =sumproduct((A1:A4412="purchase")*(B1:B4412)) is my preferred method



that method adds 2-3 seconds time.

If you needs some excel tips, please PM me.



Hmm.

Maybe I should have used an array formala?

{=SUM(IF(A1:A4412="purchase",(B1:B4412),0))} (hit shift+ctrl+enter to create the array formula brackets).

This thread is now about excel skilz


(editted to correct formula...oops !)
Edited by tautology on Jan 26, 2010 18:20:11
Edited by tautology on Jan 26, 2010 18:13:35
 
Ubasstards
offline
Link
 
Originally posted by bug03
excel is greatest thing ever invented imo


no sure how people (especially accountants) could function without it.
 
California
knows how to party
offline
Link
 
Originally posted by tautology

Hmm.

Maybe I should have used an array formala?

{=IF(A1:E4412,SUM(B1:B4412),0)} (hit shift+ctrl+enter to create the array formula brackets).

This thread is now about excel skilz


or yknow, have some old school fun, take out a pencil and a sheet of paper and do addition. If you have a kid, tell them it's their homework assignment and you'll give them 5 bucks.
 
Link
 
Originally posted by BADGERBACKER
A hair over 1.3M.


wow u alone made bort a millionaire, no wonder he'll never hire another programmer
 
California
knows how to party
offline
Link
 
Originally posted by BADGERBACKER
A hair over 1.3M.


1 million flex package = Bort goes face first into your crotchmuscle

At least if there were justice in this world.
 
DL24
offline
Link
 
Originally posted by Psych
Originally posted by BADGERBACKER

A hair over 1.3M.


wow u alone made bort a millionaire, no wonder he'll never hire another programmer


flex, not $$...
 
Ubasstards
offline
Link
 
Originally posted by tautology

Hmm.

Maybe I should have used an array formala?

{=IF(A1:E4412="purchase",SUM(B1:B4412),0)} (hit shift+ctrl+enter to create the array formula brackets).

This thread is now about excel skilz


had that formula in half of my files.

Enough of this. I am taking a break from accounting and excel after 13 years of it. Formulas making me sick now
 
bombfast
offline
Link
 
Ouch shouldn't added this up 464300 flex points to date. And still buying this season to boost... time to retire some more players
 
r87
offline
Link
 
Originally posted by avgbrad
1ea Double Booster pack - 3,200


o rly
 
Cubsfan1
offline
Link
 
49k flex
 
Page:
 


You are not logged in. Please log in if you want to post a reply.