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...