Forum Discussion
Find and export from one spreadsheet to a new one
I have a spreadsheet with a field that contains up to 200 comma-separated text values indicating an area of interest in our organization. I need to search the spreadsheet for a given value in that fi...
try something like:
=FILTER(Sheet1!1:.1048576, ISNUMBER(SEARCH("Safety Team", Sheet1!$AA$1:.$AA$1048576)),"none")
note that the last row in column AA must match the last used cell on the sheet for this to work. Alternatively replace the 1:.1048576 with the actual range of the data being used or better yet Foramt as Table and reference the TABLE accordingly.