CODEWITHSUNDEEP
regexgoogle-sheetsfiltergoogle-sheets-formulatextjoin
sebas
sebas

Reputation: 742

Google Sheet Filter excluding duplicates with condition

Having this example sheet (just sample data)

       Column-A      Column-B                    Column-C
  1    claudia       [email protected]           SOLD
  2    claudia       [email protected]           CONTACTED
  3    natalia       [email protected]           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)

Upvotes: 0

Views: 544

Answers (1)

player0
player0

Reputation: 1

try like this:

=FILTER(A1:C, C1:C="contacted", 
 NOT(REGEXMATCH(B1:B, TEXTJOIN("|", 1, FILTER(B1:B, C1:C="sold")))))

enter image description here

Upvotes: 2

Related Questions