=MATCH(COUNTA(B1:H1),LEN(SUBSTITUTE(INT(MMULT(IFERROR(10^MATCH($M$1:$AC$120000,B1:H1,0),0),TRANSPOSE(COLUMN($M$1:$AC$120000)^0))/10),0,"")),0)
This formula is looking for matches but full exact matches from one table in another one as in attached file
i need it to be remade so it will be able to find partial matches of 6 or 5 or 4 or 3 or 2 or 1 with same logic as it is now
order of found matches in the row can be any order
thanks a lot
This formula is looking for matches but full exact matches from one table in another one as in attached file
i need it to be remade so it will be able to find partial matches of 6 or 5 or 4 or 3 or 2 or 1 with same logic as it is now
order of found matches in the row can be any order
thanks a lot