G
Guest
Hello, Could somebody please help me with the following
I have a row of numbers and the letter x. the numbers are always sequential
except when an x marks a non working day.
A B C D E F G H
I J K
ROW1 x 1 2 3 4 5 x x 6 7 8
ROW2
In Row 2 I would like to get the cell address of the previous cell that does
not have an x in Row1.
Eg. Cell I2 would return the address of cell F2
Cell D2 would return the address of cell C2
I am going to embed this cell address in another formula.
I have a row of numbers and the letter x. the numbers are always sequential
except when an x marks a non working day.
A B C D E F G H
I J K
ROW1 x 1 2 3 4 5 x x 6 7 8
ROW2
In Row 2 I would like to get the cell address of the previous cell that does
not have an x in Row1.
Eg. Cell I2 would return the address of cell F2
Cell D2 would return the address of cell C2
I am going to embed this cell address in another formula.