Search
 
SCRIPT & CODE EXAMPLE
 

PYTHON

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.
Comment
PREVIOUS NEXT
Code Example
Python :: install python 3 on mac 
Python :: pil image from numpy 
Python :: requests get cookies from response 
Python :: loading text file delimited by tab into pandas 
Python :: opencv imshow resize 
Python :: os walk example 
Python :: how to get the amount of nan values in a data fram 
Python :: python subtract 2 strings 
Python :: django message framework 
Python :: python list inversion 
Python :: check all python versions ubuntu 
Python :: print list vertically in python with loop 
Python :: drop index in multiindex pandas 
Python :: python how to install numpy on pycharm 
Python :: python yaml parser 
Python :: calcolatrice online 
Python :: dict to array of string python 
Python :: seconds in a month 
Python :: time date in pandas to csv file 
Python :: django make migrations 
Python :: python read column from csv 
Python :: pandas drop rows with empty list 
Python :: encoding read_csv 
Python :: sum of 1 to n number in python 
Python :: can you edit string.punctuation 
Python :: how to find shortest string in a list python 
Python :: decode base64 with python 
Python :: python download file from web 
Python :: can you print to multiple output files python 
Python :: python delete header row 
ADD CONTENT
Topic
Content
Source link
Name
5+3 =