How do identify if a number is NOT in an array?

[Ed]

I want to know if a part number is NOT listed in the array of future demand.

 

[Francis]

try the bulit-in Find feature in Excel from Edit >> Find
this iwill tell you whether or not the dataset have the number/string

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another