Helpful Google Sheets Formulas #Sheets #Google

Filter Formla Examples

 https://blog.coupler.io/filter-function-google-sheets/

Filter Using Importrange

 =FILTER(IMPORTRANGE("spreadsheet", "cell_range"),[condition_1, condition_2,...])

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)
   )
)