Find values in a two dim array that are not also in another column

[Dichotomy66]

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

[#2 · Accepted solution]

@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]

Thanks this worked great and was easy to adapt to other with similar situation

[#4]

@Dichotomy66 , you are welcome