I have set up a row whose cells can contain one of three values, “A”, “Z” or “”. I want to find the index of the first cell to the left of a given cell.
|| A______Z__A___Z 111111 123456789012345
Cell C15 is the cell I am referencing from.
Cell C11 is the cell I am looking for the index to.
MATCH seems to always go back to C1. I want to find the index to C11.