Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MATCH function - 2 columns w/ SIMILAR, not EXACT data | Excel Worksheet Functions | |||
Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions | |||
how to build a formula to match numbers in 2 columns with the equ. | Excel Worksheet Functions | |||
How do i Match all COLUMNS? | Excel Worksheet Functions | |||
HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ? | Excel Worksheet Functions |