Forum Discussion
Solved
Find values in a two dim array that are not also in another column
I have a two dimensional array $s$5:$v$14 that contains numbers and blanks derived from formulas within
In $w$5:$w$14 are numbers
I want in col $X to list the numbers from $w$5:$w$14 that are not in the array $S$5:$v$14
Dichotomy66 , if like this
when in X5
=IFERROR(INDEX($W$5:$W$14,AGGREGATE(15,6,1/(COUNTIF($S$5:$V$14,$W$5:$W$14)=0)*(ROW($W$5:$W$14)-ROW($W$4)),(ROW()-ROW($X$4)) )),"")
and drag it down
3 Replies
Dichotomy66 , if like this
when in X5
=IFERROR(INDEX($W$5:$W$14,AGGREGATE(15,6,1/(COUNTIF($S$5:$V$14,$W$5:$W$14)=0)*(ROW($W$5:$W$14)-ROW($W$4)),(ROW()-ROW($X$4)) )),"")
and drag it down
- Thanks this worked great and was easy to adapt to other with similar situation
Dichotomy66 , you are welcome
