CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Elad Benda
Elad Benda

Reputation: 36656

Match over a concatenation of a whole column?

I want to collect only the rows which are different between two tables.

The PK are the first two columns.

How can I fix this formula? I guess I use V:W incorrectly.

=if(Q11&" "&R11="","", isnumber(match(Q11&" "&R11, V:W,0)))

enter image description here

Upvotes: 0

Views: 32

Answers (1)

Krzysztof Dołęgowski
Krzysztof Dołęgowski

Reputation: 2660

Let's say that you have 'today' data in column B And 'last time' data in column C

And you want to get values that exist only in 'today' column but not in 'last time'.

You can use:

=query(
ArrayFormula(
if(countif(C2:C,B2:B)=0,
    B2:B,
    ""
)),
"select Col1 where Col1 <> ''"
)

As you use more columns in your datatable, you can concatenate and use for example: C2:C&" "&D2:D&" "&E2:E instead of one column.

Upvotes: 2

Related Questions