Find similar values in different column and generate a matrixOn 01/22/2019 at 16:52MMatthieuB08NewcomerPosts1Excel2016 FRRegistered01/22/2019 Dear all,I wondering if there is a formula that could help me to obtain the following output (in orange) table : Thanks in advanceOn 01/22/2019 at 19:16bigdaddy154Involved MemberPosts1,204Excel2010Registered03/05/2014Hi MatthieuB08,test this file if it's you're wondering.Good evening. 14matthieub08.xlsx (10.58 KB) Search for threads similar to "find similar values different column generate matrix"ForumsExcel - VBAFind similar values in different column and generate a matrix