Announcement

Collapse
No announcement yet.

Excel guru needed

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

  • #16
    Ah, I see now.

    What's the max # of tail #'s you can have in any one spot? 2?
    "Laws that forbid the carrying of arms...disarm only those who are neither inclined nor determined to commit crimes...Such laws make things worse for the assaulted and better for the assailants; they serve rather to encourage than to prevent homicides, for an unarmed man may be attacked with greater confidence than an armed man." - Thomas Jefferson, 1776

    Comment


    • #17
      Originally posted by BLK306 View Post
      Alright I entered it just like this and got the #N/A error

      =INDIRECT("STATUS!B"&(MATCH(11,STATUS!B6:STATUS!B8 6,0))+4)-1
      Try putting the parking spot in quotes (I'm thinking it's a number stored as text, so 11 and "11" aren't the same) and drop the -1 on the end (the offset is already accounted for with +4 instead of +5)

      =INDIRECT("STATUS!B"&(MATCH("11",STATUS!B6:STATUS! B86,0))+4)
      Originally posted by Broncojohnny
      HOORAY ME and FUCK YOU!

      Comment


      • #18
        Originally posted by BlackGT View Post
        Ah, I see now.

        What's the max # of tail #'s you can have in any one spot? 2?
        1 tail number per parking spot.

        Comment


        • #19
          Originally posted by Nash B. View Post
          Try putting the parking spot in quotes (I'm thinking it's a number stored as text, so 11 and "11" aren't the same) and drop the -1 on the end (the offset is already accounted for with +4 instead of +5)

          =INDIRECT("STATUS!B"&(MATCH("11",STATUS!B6:STATUS! B86,0))+4)
          This is correct format. Have to wrap "" around the sheet name, but sheet name has to begin with ' and end with '!
          =INDIRECT("'Tail # & Parking Spot'!B"&(MATCH(1,'Tail # & Parking Spot'!B6:'Tail # & Parking Spot'!B86,0))+4)

          This should get you what you need!
          Good Job Nash!!!
          "Laws that forbid the carrying of arms...disarm only those who are neither inclined nor determined to commit crimes...Such laws make things worse for the assaulted and better for the assailants; they serve rather to encourage than to prevent homicides, for an unarmed man may be attacked with greater confidence than an armed man." - Thomas Jefferson, 1776

          Comment


          • #20
            Originally posted by Nash B. View Post
            Try putting the parking spot in quotes (I'm thinking it's a number stored as text, so 11 and "11" aren't the same) and drop the -1 on the end (the offset is already accounted for with +4 instead of +5)

            =INDIRECT("STATUS!B"&(MATCH("11",STATUS!B6:STATUS! B86,0))+4)
            That just has it coming back with a value of 0.

            Comment


            • #21
              Ah, change +4 to +3 because you've got the merged cells.
              Originally posted by Broncojohnny
              HOORAY ME and FUCK YOU!

              Comment


              • #22
                Should look like this. with formula ending in ))+3)
                "Laws that forbid the carrying of arms...disarm only those who are neither inclined nor determined to commit crimes...Such laws make things worse for the assaulted and better for the assailants; they serve rather to encourage than to prevent homicides, for an unarmed man may be attacked with greater confidence than an armed man." - Thomas Jefferson, 1776

                Comment


                • #23
                  Originally posted by Sean88gt View Post
                  Nassty Nate knows his way around excel.
                  Shhh don't tell anyone.

                  Nash b covered it just fine.

                  Comment


                  • #24
                    Originally posted by Nash B. View Post
                    Ah, change +4 to +3 because you've got the merged cells.
                    That got it! Thanks

                    Comment

                    Working...