Forum Discussion
Multiple variables to evaluate a row
I need a formula hat evaluates the cells in the column below it and returns the answer A: Y,Y,N,N = return a N B: Y,Y,Y,Y = return a Y C: Y,N,NA,NA = return a N 😧 Y,Y,NA,NA = return a Y E: ...
As variant
=BYCOL(
B2:G6,
LAMBDA(a,
IFERROR(
INDEX(
FILTER(Priority, COUNTIF(a, Priority) > 0),
1
),
""
)
)
)