Thank you for your solution. Another formula... =LET(u,UNIQUE(TOCOL(B3:H9)),SORT(FILTER(u,MAP(u,LAMBDA(x,SUM(--BYCOL(B3:H9=x,O))))>3)))
@excelkid5 ай бұрын
Looks great!
@ijazulhaqbadar932227 күн бұрын
What does "u" stand for?
@sashisharma42495 ай бұрын
one can use this as well:- =FILTER(A2:A200, (XLOOKUP(A2:A200, B2:B200, B2:B200,"")"")*(XLOOKUP(A2:A200, C2:C200, C2:C200,"")"")*(XLOOKUP(A2:A200, D2:D200, D2:D200,"")""))