1

As the title says, I need a column to show what is not on a range(BASIS) that is in the other sheet(BASIS)

enter image description here:

I've been searching for hours now but only found the opposite results.

  • Can you rephrase your question, please? You say you want to find things in "the other that are not in the other". – ale Jul 15 at 1:11
0

=FILTER(A1:A1000, NOT(COUNTIF({C1:C500; D1:D500}, A1:A1000)))

0


=FILTER(A1:A, NOT(REGEXMATCH(A1:A, TEXTJOIN("|", 1, C1:D))))

0

Not the answer you're looking for? Browse other questions tagged or ask your own question.