Finding a match in several columns

K

Keren

Hi,

I have 4 columns in my excel sheet. Some of the cells (content) appear
in all columns and some don't.
I would like to have a formula which finds the cells that appear in all
4 columns and would write them in a different column.

Is there such a formula?

Thank you,
Keren
 
D

duane

how about the following - looking at columns a:d for "thing"

if(and(countif(a:a,"thing")>0,countif(b:b,"thing")>0,countif(c:c,"thing")>0,countif(c:c,"thing")>0),"thing","")

search for at least one occurance of "thing" in each of columns a:d
 
D

duane

well then instead of counting "thing", count whatever is in column a

if(and(countif(a:a,a1)>0,countif(b:b,a1)>0,countif(c:c,a1)>0,countif(c:c,a1)>0),a1,"")

maybe in column e and copied down for the rows of data?

alternatively, a macro could do the same search
 
Top