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

Question

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.

detlef_lewin · Answer

MLowrey70&nbsp;Try this:=FILTER(A2:A18,1-COUNTIFS(B2:B6,A2:A18))

yea_so · Answer

Hi&nbsp;MLowrey70&nbsp;&nbsp;=IF(IF(ISNUMBER(MATCH(A2,$B$2:$B$6,0)),"",A2)=0,"",IF(ISNUMBER(MATCH(A2,$B$2:$B$6,0)),"",A2))&nbsp;you have to adjust the range&nbsp;$B$2:$B$6 to match that range in your application.&nbsp;Cheers

Forum Discussion

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

2 Replies

Resources