regexgoogle-sheetsfiltergoogle-sheets-formulatextjoin
Google Sheet Filter excluding duplicates with condition
Having this example sheet (just sample data)
Column-A Column-B Column-C
1 claudia claudia@gmail.com SOLD
2 claudia claudia@gmail.com CONTACTED
3 natalia natalia@gmail.com CONTACTED
How to use FILTER to filter row 3, that is to say: rows where colum-c is CONTACTED but excluding duplicated rows where one of the duplicated instances has "SOLD" within column-c.
Definition of "duplicate": same email (column-b)
Solution
try like this:
=FILTER(A1:C, C1:C="contacted",
NOT(REGEXMATCH(B1:B, TEXTJOIN("|", 1, FILTER(B1:B, C1:C="sold")))))
- osmdata_sf returns failed to perform HTTP request curl::curl_fetch_memory() error in R?
- Sub-subtitle in a graph made with `ggplot2`
- How can I execute a statement and ignore warnings with tryCatch?
- Enumerate events where n consecutive values are not NA
- Serialize/deserialize a column with R and DuckDB
- Replicate matrix
- Putting multiple plots on the same page in R?
- NA values in a non-editable date column in a datatable in a shiny app change to "Invalid Date" when clicked on
- How to enable/disable checkboxInput when certain panel is selected
- Writing robust R code: namespaces, masking and using the `::` operator
- Replacing with conditional value in dplyr case_when()
- How to assign pre-determined RGB values to polygons
- python/pandas equivalent to dplyr 1.0.0 summarize(across())
- Calculating moving average
- Estimating non-monotonic bi-exponential curve fit
- column type issue when converting csv to parquet using duckdb in R
- "Target position can only be set for new windows" in chromote in R
- Determine level of nesting in R?
- Week start on Mondays
- Center output from dm_draw
- plot a network based on given values
- Adding a X axis title to faceted ggballoonplot
- Calculate mean of matrices having different dimensions
- check if two columns have a one-to-one relationship in R
- How to extract Std.Dev from VarCorr glmmTMB
- How do you print to stderr in R?
- How to plot China map with South China Sea in base R
- Get column and row position of nth element in a matrix
- Is there any authoritative documentation on R release nicknames?
- R Glassdoor Web Scraping