Hi all,
I've been trying to return a date value from the first non blank cell in a row, but for some reason the formula keeps returning the value from the last cell in the range rather than the first non-blank cell. I've been using the following formula:
=INDEX(range,MATCH(FALSE,ISBLANK(range),0))
Any ideas or suggestions on how to solve this would be greatly appreciated!
I've been trying to return a date value from the first non blank cell in a row, but for some reason the formula keeps returning the value from the last cell in the range rather than the first non-blank cell. I've been using the following formula:
=INDEX(range,MATCH(FALSE,ISBLANK(range),0))
Any ideas or suggestions on how to solve this would be greatly appreciated!