Finding a match in several columns
 

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


--
Keren
------------------------------------------------------------------------
Keren's Profile: http://www.excelforum.com/member.php...o&userid=23755
View this thread: http://www.excelforum.com/showthread...hreadid=374133

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


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=374133

I don't know the "thing" I'm looking for in advance.
I need it to give me all the strings that appear in all 4 columns.

Thanks for the suggestion anyway.


--
Keren
------------------------------------------------------------------------
Keren's Profile: http://www.excelforum.com/member.php...o&userid=23755
View this thread: http://www.excelforum.com/showthread...hreadid=374133

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


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=374133