regexgoogle-sheetsgoogle-sheets-formulagoogle-sheets-querygoogle-query-language
Import data: one column specific value must have, another column several value have too
Suppose, I want to import data from separate spreadsheetA to spreadsheetsheetB, where Column D have 'play' or 'poetry' or fiction and Column E must have '200'. How it possible?
https://docs.google.com/spreadsheets/d/1v_RQvFPxLJSN3k6urCcIXt2BsRlbc-sgaiGAP_aH1Y4/edit#gid=0
Solution
=QUERY(A!A2:M, "where lower(D) matches 'play|poetry|fiction' and E = 200", 1)
- Replace variables in a formula with their definitions
- Replace letters inside words that start with and end with a specific letter not occurring anywhere else with the same amount of a specific character
- regex for expression with one separator hyphen
- open vimeo url in colorbox using jQuery filter
- Split address and numbers
- Pyspark Regular Expression add double quotes after comma
- In the regex world what's a flavor and which flavor does Java use?
- Problems with table extraction using pdfplumber - empty fields in large tables
- How do I pass a variable into regex with Node js?
- How do I use regex in a SQLite query?
- Python RegEx: match words in a string only if they are not preceded by a specific character
- Regular expression that ignores HTML entities
- Allow access to page only from certain referrer
- Regex to match string containing two names in any order
- Matching boot times from log using sed -E
- Validate Bangladeshi phone number with optional +88 or 01 preceeding 11 digits
- Using setCustomValidity stops input from validating
- Use dynamic (variable) string as regex pattern in dart
- Regular expression matching Android package name
- Replace commas not inside single quotes with an @ symbol
- Visual Studio Code Search and Replace with Regular Expressions
- Split string on commas not inside double quotes
- Extracting specific data from a string with regex and Powershell
- Parse datetime string in Ydm.His format
- Extract all words double wrapped in curly braces
- Parse dot-delimited video filename to extract show title, series number and episode number
- Split a string into words, preserving contractions but removing leading apostrophes from words
- Split string on pipes which are not between square braces
- Simple regex pattern for email
- How to extract filename without extension in Makefile