T
Tony Gardner
Just spent ages typing out my query and I can't see it posted
anywhere...
I need the MATCH function to ignore blank cells and return the row of
the next value in an array.
i.e, if A1 is blank and A2 contains 3, I need to return 2 from looking
in the array "A1:A2"
Cheers
anywhere...
I need the MATCH function to ignore blank cells and return the row of
the next value in an array.
i.e, if A1 is blank and A2 contains 3, I need to return 2 from looking
in the array "A1:A2"
Cheers