Skip to content

Instantly share code, notes, and snippets.

@landbryo

landbryo/sheets_filter

Last active May 23, 2018 15:06
Show Gist options
  • Save landbryo/6bc5fa69374ede4ac0d76f0ecef026ad to your computer and use it in GitHub Desktop.
Save landbryo/6bc5fa69374ede4ac0d76f0ecef026ad to your computer and use it in GitHub Desktop.
Download ZIP
Detailed description in file.
Raw
sheets_filter
`=filter( A2:I, search("Yes", I2:I) )`
### Determins where you start and end. This example starts in cell A2 and ends before column I begins ###
`A2:I`
### Term to search for ###
`"Yes"`
### Determins where you return the results. This example returns the results in column I starting at cell I2 ###
`I2:I`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment