ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do identify if a number is NOT in an array? (https://www.excelbanter.com/excel-discussion-misc-queries/227727-how-do-identify-if-number-not-array.html)

Ed

How do identify if a number is NOT in an array?
 
I want to know if a part number is NOT listed in the array of future demand.

Francis[_2_]

How do identify if a number is NOT in an array?
 
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



"Ed" wrote:

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



All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com