BYCOL & BYROW
Hi,
Below formula throwing #Calc error:
BYCOL(C3#,LAMBDA(ColHdrs_1,
BYROW(B4#,LAMBDA(RowHdrs_1,
IFERROR(COUNTA(UNIQUE(FILTER($K$3:$K$25,($I$3:$I$25=RowHdrs_1)*($J$3:$J$25=ColHdrs_1)))),0)))))
Need one array formula.
Hi, Below formula throwing #Calc error:BYCOL(C3#,LAMBDA(ColHdrs_1,BYROW(B4#,LAMBDA(RowHdrs_1,IFERROR(COUNTA(UNIQUE(FILTER($K$3:$K$25,($I$3:$I$25=RowHdrs_1)*($J$3:$J$25=ColHdrs_1)))),0))))) Need one array formula.Sheet Read More