Hi,
I have a row that contains text in some of the cells, e.g.:
_ _ A _ B _ _ _ C _ _ _ _ _ D _ _ D _ _ _ E.
Where _ represents an empty cell.
I need that the next row will show me the number of empty cells to the left of each of the non empty cells, with an exaction that if it's the same letter it skip it, e.g.:
_ _ 0 _ 2 _ _ _ 4 _ _ _ _ _ 6 _ _ _ _ _ _ 7.
I tried to use INDEX and MATCH functions to find the first non empty cell but I don't know how to define the list which I need to check.
Any suggestion Will be highly appreciated.
I have a row that contains text in some of the cells, e.g.:
_ _ A _ B _ _ _ C _ _ _ _ _ D _ _ D _ _ _ E.
Where _ represents an empty cell.
I need that the next row will show me the number of empty cells to the left of each of the non empty cells, with an exaction that if it's the same letter it skip it, e.g.:
_ _ 0 _ 2 _ _ _ 4 _ _ _ _ _ 6 _ _ _ _ _ _ 7.
I tried to use INDEX and MATCH functions to find the first non empty cell but I don't know how to define the list which I need to check.
Any suggestion Will be highly appreciated.