Answers for "filter an importrange"

Whatever

1

filter an importrange

=FILTER(
  IMPORTRANGE(“SpreadsheetURL”,”SheetName!A:C”),
  INDEX(IMPORTRANGE(“SpreadsheetURL”,”SheetName!A:C”),0,3)=”SomeText”
)

Note:
- The last parameter of index denotes what column number to filter the array by.
In the above example, we are filtering the array by Column 3 and returning
results that match SomeText in Column 3.

Posted by: Guest on April-20-2022

Source

Code answers related to "filter an importrange"

Code answers related to "Whatever"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#