May 13 2021 02:07 PM
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.
May 13 2021 02:29 PM
May 13 2021 02:43 PM - edited May 13 2021 02:49 PM
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