Hi all,
I am trying to call the row number for a value, but there could be a duplicate, so I want to call the final cell with that value.
Here's the situation. I used this function (=LOOKUP(9.99E+307,B:B)) to get the value of the last cell a with a value in column B. This works fine. The last cell's value comes up just like I expected.
Then, I used the MATCH function to get the row number for the cell. Again, works just fine... Except that on occasion, I can have a duplicate come up in column B. If there's a duplicate, the MATCH function finds the first instance of the value found using LOOKUP and returns the wrong row number (the first instance rather than the last).
Any solutions?
Thanks for your help!
I am trying to call the row number for a value, but there could be a duplicate, so I want to call the final cell with that value.
Here's the situation. I used this function (=LOOKUP(9.99E+307,B:B)) to get the value of the last cell a with a value in column B. This works fine. The last cell's value comes up just like I expected.
Then, I used the MATCH function to get the row number for the cell. Again, works just fine... Except that on occasion, I can have a duplicate come up in column B. If there's a duplicate, the MATCH function finds the first instance of the value found using LOOKUP and returns the wrong row number (the first instance rather than the last).
Any solutions?
Thanks for your help!