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 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.
alannavarro Thank you very much, this is exactly what I needed.