Feb 06 2022 02:59 PM
I would like to find the first blank cell and then the value in the cell to the left - i.e. "Tuesday".
The formula below finds the blank cell and returns the cell address $C$6
=CELL("address",INDEX(B5:D11,MATCH(TRUE,ISBLANK(C5:C11),0),2))
I was hoping to use the OFFSET function but it hasn't worked. Any suggestions?
Feb 06 2022 03:07 PM
SolutionFeb 06 2022 03:11 PM
Thank you so much...so simple! @Hans Vogelaar
Feb 06 2022 03:07 PM
Solution