Forum Discussion
Venn diagram or names in a list
Hi I would like to make a venn diagram using three circles to show the overlap between three lists of names. I dont want to use the art version of it, I want it to populate from data. I have attac...
Hi Sergi
Thank you very much for your reply. I understand how the index and match works and it does exactly what I asked but I was also wondering if I can use the same formula to see which names are in columns 1, 2 ands 3? Match only seems to work with two columns.
I can kind of see how the G and T thing works but I can work out how to edit it to add one that compares all three columns.
Thank you very much again
Ian
Hi Ian,
You may use nested INDEX/MATCH. If you have column with "1-2" overlapping list, INDEX/MATCH values in this column on third column in your source table, you'll have "1-2-3" overlapping combination. If you don't need "1-2" use formula for it as search value in "1-2-3", i.e. final formula will be
=IFERROR(INDEX(Table1[3],MATCH(IFERROR(INDEX(Table1[2],MATCH(Table1[@1],Table1[2],0),0),""),Table1[3],0)),"")
Here
and in attached file