Skip to content

Instantly share code, notes, and snippets.

@RR-Helpdesk

RR-Helpdesk/Filter Formla Examples

Last active June 10, 2023 12:09
Show Gist options
  • Save RR-Helpdesk/96bcab5da177a92d360dfcf6167c70e0 to your computer and use it in GitHub Desktop.
Save RR-Helpdesk/96bcab5da177a92d360dfcf6167c70e0 to your computer and use it in GitHub Desktop.
Download ZIP
Helpful Google Sheets Formulas #Sheets #Google
Raw
Filter Formla Examples
https://blog.coupler.io/filter-function-google-sheets/
Raw
Filter Using Importrange
=FILTER(IMPORTRANGE("spreadsheet", "cell_range"),[condition_1, condition_2,...])
Raw
Remove Duplicates in Range
=FILTER(
UNIQUE(cell_range),
ARRAYFORMULA(
COUNTIF(cell_range,
UNIQUE(cell_range))>1
)
)
=iferror(
filter(
unique(A2:A),
arrayformula(
countif(A2:A,
unique(A2:A))>1)
)
)
=iferror(
filter(
unique(B2:B),
arrayformula(
countif(B2:B,
unique(B2:B))>1)
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment