Harry0
Member
I tried to use {=INDEX(range,MATCH(FALSE,ISBLANK(range),0))}
But it does not seem to work despite I thought that it did
{=INDEX(AB1:HY1,MATCH(FALSE,ISBLANK(AB3:HY3),0))}
Any other formulas to suggest?
The top row has dates and under it has many rows and I need to find for each row when it first had a number.
I am using 2011 excel
Thanks
But it does not seem to work despite I thought that it did
{=INDEX(AB1:HY1,MATCH(FALSE,ISBLANK(AB3:HY3),0))}
Any other formulas to suggest?
The top row has dates and under it has many rows and I need to find for each row when it first had a number.
I am using 2011 excel
Thanks
Last edited: