Extracting Values Common To 4 Lists

[hochedez]

Hello!

Sorry, another duplicate question... I couldn't find the answer to m
problem in any of the usual websites or recent posts so here it is:

Very simple. I have 4 list of location names, listed in 4 columns.
The number of entries in each column varies.

I would like to list the names that appears in ALL of these lists (i.e
column A, B, C,D) in, let's say, column E. (in other words, column
would be a list of names that are in column A AND column B AND column
AND column D).

Thanx you for your help!

Benoit H

 

[Frank Kabel]

Hi
enter the following formula in E1
=IF(AND(COUNTIF($A$1:$A$10,D1)>0,COUNTIF($B$1:$B$10,D1)>0,COUNTIF($C$1:
$C$10,D1)>0),D1,"")
and copy down

after this you may copy the values with 'Paste Special' and
filter/delte the blank rows

 

[hochedez]

Thank you Frank (once again!)

The formula works perfectly

Cordially,
Benoi