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):
=IF('ALL CUSTOMERS'!J2:R1216>=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.
