LISTS! identifying unique values in multiple lists

**pwall1115** · 04-08-2013, 10:37 PM

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!!!

**rylo** · 04-09-2013, 12:08 AM

Hi

Where are the lists? Same sheet? Different sheets in same workbook? Beside each other? Below each other?

rylo

**FDibbins** · 04-09-2013, 12:08 AM

you could do this with a few nested if()'s and vlookup() or countif()'s

I would need to see a sample of the lists to give a better suggestion

**wenqq3** · 04-09-2013, 03:36 AM

Suggest vlookup, to find match "name".
or match(), if you want know which row.

If there is repeated name at same file/list, suggest use countif() or pivot table to find it out.
Hope it help.