Skip to content

Instantly share code, notes, and snippets.

@gppam

gppam/combinenfilter.md

Last active April 30, 2019 01:12
Show Gist options
  • Save gppam/193311294b4de11d188f2912b5a713f9 to your computer and use it in GitHub Desktop.
Save gppam/193311294b4de11d188f2912b5a713f9 to your computer and use it in GitHub Desktop.
Download ZIP
Combine columns and filter in Google Sheets
Raw
combinenfilter.md

Combines columns D, E, and F and filters each of them, in this case a specific date string.

=ARRAYFORMULA(FILTER('Responses'!D:D, 'Responses'!C:C="April 30 - May 1")&" "&(FILTER('Responses'!E:E, 'Responses'!C:C="April 30 - May 1")&" - "&(FILTER('Responses'!F:F, 'Responses'!C:C="April 30 - May 1"))))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment