=LET(FindTerms,LAMBDA(row,LET(prelim,TEXTSPLIT(row,"/"),words,FILTER(prelim,LEN(prelim)>2),SUM(IFNA(XMATCH("*"&words&"*",ListofTerms,2),0))),BYROW(terms,FindTerms)) Whiteness Viscosity (cP,1% KCl) Shear ratio Moisture/Loss on drying10 Ash/Residue on ignition...
Hi, I have a problem to count how many different cells per person in a list, either I can count avoiding the duplicates but empty cells are a problem, or count avoiding empty cells and duplicates are... Marc56 In G3: =COUNTA(UNIQUE(FILTER($C$3:$C$14, ($B...
Hi, I have a problem to count how many different cells per person in a list, either I can count avoiding the duplicates but empty cells are a problem, or count avoiding empty cells and duplicates are... Marc56Another option with Excel for MS365: =LET(data,UNIQUE...
Hi, I have a problem to count how many different cells per person in a list, either I can count avoiding the duplicates but empty cells are a problem, or count avoiding empty cells and duplicates are... Marc56Another option with Excel for MS365: =LET(data,UNIQUE($C$3:$D$14),in...