Comparing columns and reporting results in a Venn diagram

Hi,

I want to compare the names in 4 columns. The output should be the number of names in common among all the columns and the names in common between pairs and triple columns. With this info, I would then draw a Venn diagram.

Thank you