So by this method I guess I will be doing pairwise comparison, Isnt there any
option to compare more than two lists, all at once?

"Pete" wrote:

Sorry, I missed your first question. Using the common list from column
C in conjunction with a third list, the same approach can be taken to
give you another list which is common to all three original lists.
Apply the same for 4 or more lists.

Hope this helps

Pete