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 field and export all the rows that contain the specified value to a new spreadsheet.
For example: Search the Employee spreadsheet for the occurrence of the text string Safety Team in column AA, and export all the indicated rows to a new spreadsheet named Safety Team.
1 Reply
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.
