Hi, I regularly have three lists of names (ListA, ListB, ListC) that I need to compare and create a Venn diagram to show the number of common and unique names from the lists and then display the results in a 3 way Venn Diagram. I know there isn't a Venn Diagram chart template in Excel so I create one using circle shapes and then add text boxes with links to the data. But my question is how best to get the numbers for the Venn Diagram. Currently I am using multiple comparisons of the tables using lookup functions. Is there a PQ way of doing this, I wonder?

Thanks