Find similar values in different column and generate a matrix

Dear all,

I wondering if there is a formula that could help me to obtain the following output (in orange) table :

formula

Thanks in advance

Hi MatthieuB08,

test this file if it's you're wondering.

Good evening.

5matthieub08.xlsx (10.58 Ko)
Rechercher des sujets similaires à "find similar values different column and generate matrix"