I am relatively inexperienced with Excel: about the most advanced thing I have done is process data with VLOOKUP.

I would like to analyze the contents of 2 - 3 lists to determine what is shared among all of the lists, 2 out of three of the lists, and unique to each list. Essentially this is like creating a Venn diagram from 3 sets, which is exactly what I want to do, but I also want the resulting lists for further analysis. Is there a general way to do this with Boolean logic in Excel?

Thanks, this is my first post to your forum...