Forum Discussion
Solved
AND function for each column in a spilled range
So currently I have a range of numbers B1:O6 (this range will eventually get larger), to which I am comparing to A1:A6 (this too will get larger). i.e. Each cell in row 1 is compared to A1, Each cell...
SStandrin I think this is what you were asking for... hope it helps.
I first did the formulas one at a time , then in the bottom I did all of them inside one formula with let.
To make it dynamic I had to transform the data into tables.
SStandrin If you have the lambda function, I believe you could also try:
=LET(isColGreater, BYCOL(B1:O6, LAMBDA(col, SUM(--(col<=A1:A6))=0)),
isColGreater)
that is great! I still don´t have lambda in excel... looks really good and simple formula