Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
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
No comments:
Post a Comment