Announcement

Collapse
No announcement yet.

OpenOffice Spreadsheet question

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #31
    You used INDEX and MATCH, I presume?
    <Reverend> IRC is just multiplayer notepad.
    I like your SNOOPY POSTER! - While you Wait quote.

    Comment


    • #32
      Originally posted by snoopy369
      You used INDEX and MATCH, I presume?
      No, I added another(hidden) column in front of the rankings which labels those that are tied 1,2,...,n.
      "

      Comment


      • #33
        Ah, that's another solution (though messier, but it does certainly work).
        <Reverend> IRC is just multiplayer notepad.
        I like your SNOOPY POSTER! - While you Wait quote.

        Comment


        • #34
          Originally posted by snoopy369
          You used INDEX and MATCH, I presume?
          I saw this solution also, but honestly I didn't understand it never having used those functions before.
          "

          Comment


          • #35
            Index and Match can be used to find a particular element of an array, ie, if you have 20 cells, you can use them to find the 13th element. In the case you described, you would use them to select the first or second or whatever out of your lookup-returned array.
            <Reverend> IRC is just multiplayer notepad.
            I like your SNOOPY POSTER! - While you Wait quote.

            Comment


            • #36
              Originally posted by snoopy369
              Index and Match can be used to find a particular element of an array, ie, if you have 20 cells, you can use them to find the 13th element. In the case you described, you would use them to select the first or second or whatever out of your lookup-returned array.
              Figured it out, that works a lot better for the semi final matchups
              "

              Comment


              • #37
                I'm getting some weird behavior if I use the > or < operators and the ROW() function together if I get data from another page.

                For instance, the formula =$Rules.$E$6>2 always returns true no matter the value of $Rules.$E$6. Is this a glitch in OO or is there a logical explanation?

                Edit: Never mind I'm an idiot. E6 was formatted as text.
                "

                Comment


                • #38
                  Pro-Tip: Charts are absolute crap in OpenOffice.
                  "

                  Comment

                  Working...
                  X