Creating a VennDiagram Or Comparing 3 Lists in Excel

I have a list of names in three different states. I want to compare the lists say A, B, C to create a venn diagram. So, I need to know where Column A and B intersect, A and C, B and C, A and B and C, and just A alone, Just B alone, and just C alone.

So in the example I have posted There are 3 different columns each with different names. I want excel to create columns showing all the info mentioned above. So ex: under the ABC column would only be John and under the BC column would be Shirly.

Please let me know when you get a chance. PS- All columns might not be the same size in my actual data. I was just trying to simplify it to show you the what I was trying to accomplish.

Thank you