Hi. I am looking for an excel formular to filter the data with columns heading a-g if columns heading dog to house has "new" in the cell.

[fayo2009]

a	b	c	d	e	f	g		dog	cat	rat	nose	house	Output
123	123	123	123	123	123	123					new		126​	126​	126​	126​	126​	126​	126​
124	124	124	124	124	124	124				new			133​	133​	133​	133​	133​	133​	133​
125	125	125	125	125	125	125							138​	138​	138​	138​	138​	138​	138​
126	126	126	126	126	126	126		new
127	127	127	127	127	127	127
128	128	128	128	128	128	128			new
129	129	129	129	129	129	129
130	130	130	130	130	130	130						new	See formular below
131	131	131	131	131	131	131				new			FILTER(A4:G22,INDEX(I4:M22,,MATCH("dog",I3:M3,0))="new")
132	132	132	132	132	132	132
133	133	133	133	133	133	133		new				new
134	134	134	134	134	134	134							Looking for a formular that would look at all the values in cells I3-M3
135	135	135	135	135	135	135			new
136	136	136	136	136	136	136
137	137	137	137	137	137	137
138	138	138	138	138	138	138		new
139	139	139	139	139	139	139
140	140	140	140	140	140	140						new

 

[Fluff]

Glad we could help & thanks for the feedback.