• 540K Members
• 3,588 Online
• 644K Conversations
SOLVED

Contributor

# 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

3 Replies
Highlighted
Solution

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

@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

Highlighted

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

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

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

@Dichotomy66 , you are welcome

Related Conversations