Solve : simple Excel filter-function?

1.	Solve : simple Excel filter-function?
Answer» I suppose this isnt really PROGRAMMING PUT it's the nearest topic. I cant find out how to output data (e.g. BIRD) that is within several columns of one EXCEL datasheet into a new datasheet. The thing is that BIRD isnt always in one of the 9 columns, so I only want the rows pasted that actually have the word within the row's nine columns. This is what I think it should be like (similar): CODE: [Select]=IF('ALL CUSTOMERS'!J2:R1216&GT;=BIRD;"BIRD FOUND";"") This should mean that if in my Excel sheet "All customers" within the nine columns (J-R) the word BIRD is found, then the rows with BIRD FOUND should be pasted on my fresh sheet, otherwise blank.

Discussion