I have five lists of names, all roughly around 1000 rows long. A lot of the names are duplicates that can be found on more than one list.

I want to create a separate column beside each name that will identify which other lists they appear in.

For example

LIST 1
Column A Column B
James 1
Paul 1, 3
Mary 1,2,3,4,5


this would mean that James only appears in List 1, and is not found on any of the other lists. Paul, however, can be found on List 1 and 3. Mary appears in all 5 lists.

Any help would be MUCH APPRECIATED!!!