Creating a column that excludes values if they appear in both of two other columns

Copper Contributor

I'm in need of some assistance, and am turning to the community here for any help that can be offered. I am trying to set up a column (D) that will omit/exclude the value for a column (A) if that same value appears in another column (B). The formula we've been utilizing 

 

=IF(ROWS($1:1)*COUNT(C:C),"",INDEX(A:A,SMALL(C:C,ROWS($1:1)))) i

 

s giving us no results a. The spreadsheet that we have been working on (which is failing miserably) is attached. 

2 Replies

@MLowrey70 

Try this:

=FILTER(A2:A18,1-COUNTIFS(B2:B6,A2:A18))

Hi @MLowrey70 

 

=IF(IF(ISNUMBER(MATCH(A2,$B$2:$B$6,0)),"",A2)=0,"",IF(ISNUMBER(MATCH(A2,$B$2:$B$6,0)),"",A2))

 

you have to adjust the range $B$2:$B$6 to match that range in your application.

 

Cheers