Hey, I am attempting to use the not-in function to filter out reversal charges.
I have a reference column and a memo column. The reference column has a transaction ID and I want to filter out the charge and the reversal.
I am writing a filter Memo Number
not IN(Reference Number
) but it only outputs the reversal only. see the attached document. I want to filter out both highlighted cells. Currently, it's only showing the red line.
Another way to explain is I want the take an array and say if a memo number matches any referance number then filter out both.
example.