1. 04-01-09 08:39 AM #1
    Justin7
    Justin7's Avatar Become A Pro!
    Join Date: 07-31-06
    Posts: 8,577
    Betpoints: 1506

    Excel question...

    Assume I have MLB data organized by team... I.e. lines 101-200 are one team, 201-300 are the next, ...

    Is there an easy way to feed this data into a formula? So at the top, I would enter "1" and "2" to draw data from lines 101-200 and 201-300m and apply it in a formula (i.e. expected runs)?
    Reply With Quote Reply With Quote
  2. 04-01-09 08:57 AM #2
    Ganchrow
    Nolite te bastardes carborundorum.
    Ganchrow's Avatar Become A Pro!
    Join Date: 08-28-05
    Posts: 5,011
    Betpoints: 1088

    Quote Originally Posted by Justin7 View Post
    Assume I have MLB data organized by team... I.e. lines 101-200 are one team, 201-300 are the next, ...

    Is there an easy way to feed this data into a formula? So at the top, I would enter "1" and "2" to draw data from lines 101-200 and 201-300m and apply it in a formula (i.e. expected runs)?
    Just use named ranges and feed them in to VBA functions.
    Reply With Quote Reply With Quote
  3. 04-01-09 07:15 PM #3
    reno cool
    the meaning of harm
    reno cool's Avatar Become A Pro!
    Join Date: 07-02-08
    Posts: 3,567
    Betpoints: 7

    "That's all right" said the priest, "I wanted to know about Freight too."
    Reply With Quote Reply With Quote
  4. 04-01-09 08:12 PM #4
    Wrecktangle
    Wrecktangle's Avatar Become A Pro!
    Join Date: 03-01-09
    Posts: 1,524
    Betpoints: 3209

    Not sure exactly what the Q is, but Excel is so powerful these days, you can do this and almost everything even without VBA...just runs (far) slower than compiled.

    ...far cry from the original Visicalc...

    ...Oh yeah, nobody here knows what that is. But I bet Ganchrow does since he usta play Choplifter on a VIC-20...or was that a PET?
    Reply With Quote Reply With Quote
Top
« Previous Thread | Handicapper Think Tank | Next Thread »