Thursday, April 21, 2011

yogi_Filtering Data For A Given String Regardless Of Which Row Or Column It Is In

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

darrenmwinters said:
I want to search for a string contained anywhere within the data ... for the data in Sheet1 I want to search for the string FCF (shown in cell A2) regardless of which row or which column the string exists in


In the following I present one way of doing this by 
first creating an array of 0s ans 1s where the row containing the specified string is populated with 1 and all the other rows are poulated with 0
then I filter the data with the array of 0s and 1s as the criterion
the result is presented in the sheet FilterRowsWithStringInA2