Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ed Ed is offline
external usenet poster
 
Posts: 279
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 69
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
identify sheet number in header? Steve Excel Discussion (Misc queries) 5 December 9th 08 12:29 AM
Identify the row in which a MAX number in a column resides BarDoomed Excel Worksheet Functions 7 June 5th 08 08:23 PM
Identify if Cell is Formula or written number Claes G Excel Worksheet Functions 13 December 5th 07 05:01 PM
Identify occurence in "array" which meets condition(s) Melissa Excel Discussion (Misc queries) 3 August 18th 05 12:59 PM
Formula to Identify Column Number Michael Link Excel Discussion (Misc queries) 4 August 14th 05 03:18 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"