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
Mascarello
Jan 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.
- PeterBartholomew1Jan 21, 2022Silver ContributorI am glad your problem is sorted. The two solutions I produced are for Excel 365 insider and Excel 2019 respectively. I need a lot of practice in order to use the new functionality to its maximum effectiveness.
My formulas were intended to work despite the apparent blanks having content but, since you are able to clear them out, that will do the job.