Forum Discussion
Mascarello
Jan 19, 2022Copper Contributor
return the date that value
Hallo, I need the hightlight column to return the date that value is filled in
alannavarro
Jan 20, 2022Iron Contributor
- MascarelloJan 20, 2022Copper Contributor
- PeterBartholomew1Jan 20, 2022Silver Contributor
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.
- MascarelloJan 21, 2022Copper Contributor
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.