Forum Discussion
How to: display value if ANY cell within a row has a non-zero value?
I’m looking for a formula to put in Column E that will automatically look at the cells in Columns B-C-D of the same row and IF there is a value in ANY of those cells, the value will be displayed in C...
= BYROW(voted, Partyλ)
Partyλ
= LAMBDA(v,
LET(
party, UNIQUE(FILTER(v, v <> "", "n/a"), 1),
consistent, COUNTA(party) = 1,
IF(consistent, party, "ERROR")
)
)
Don't see why changing party should be an error though. Henry could be seen as the sanest cookie in the jar!
This is for 365 (or 2021) only.