Select All Columns Where Cell In Columns Contain A Word - Google Sheets

by Keran Smith   Last Updated October 18, 2019 21:03 PM - source

I am looking for a query formula that will allow me to select all columns (entire column) that contain a specific word within the column.

You can see a test sheet here: https://docs.google.com/spreadsheets/d/1aP7sDTf0xlxQFK51wiswiXcIMKvUNL_3hpi0qhDCvx4/edit#gid=0

For this example, I would like a query that would scan Sheet1 and select all columns that contain the words "Adam". This would select Columns A-D.

Any help would be appreciated.

Thanks.



Related Questions




Adding missing dates to Google Sheets

Updated September 20, 2019 15:03 PM