Jan 19 2022 02:33 PM - edited Jan 19 2022 02:57 PM
Hallo, I need the hightlight column to return the date that value is filled in
Jan 19 2022 05:01 PM
Jan 20 2022 03:45 PM
@alannavarro 's solution is broadly correct. Using a different version of Excel, my solutions look somewhat different, but are broadly similar in approach
= BYROW(amount,
LAMBDA(a,XLOOKUP(TRUE,ISNUMBER(a),date,""))
)
= XLOOKUP(
TRUE,
ISNUMBER(INDEX(amount,@k,)),
date,
"")
What I have done, since you report that the >0 test does not work, is assume that the apparent blank cells in fact have text content. The ISNUMBER function works in that situation, though a 0 would then cause a wrong result.
Jan 20 2022 05:31 PM - edited Jan 20 2022 05:34 PM
On the blank cells I have a formula to calculate the value.And I dont have able the functions, Byrow and Lambda. And also I cant enable these functions. I took out the formulas of the blank cell, and the @alannavarro´s solution works correctly.
Jan 21 2022 02:28 AM