I have this formula that finds the last cell in a row that is greater than $0.00. Then it finds the date header at the top of the column.
LOOKUP(2,1/INDEX(Data!B4:GI4<>0,0,0),Data!$B$2:$FU$2)
Can it be adjusted to find the first cell?
Matt
I have this formula that finds the last cell in a row that is greater than $0.00. Then it finds the date header at the top of the column.
LOOKUP(2,1/INDEX(Data!B4:GI4<>0,0,0),Data!$B$2:$FU$2)
Can it be adjusted to find the first cell?
Matt
Re: Adjust formula from last to first
Try:
[COLOR="#0000FF"]=INDEX(Data!$B$2:$FU$2,MATCH(TRUE,INDEX(Data!B4:GI4<>0,0),0))[/COLOR]
Re: Adjust formula from last to first
Excellent. That did the trick
Thank you
Don’t have an account yet? Register yourself now and be a part of our community!