Thread: Finding values within an array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MattShoreson[_74_] MattShoreson[_74_] is offline
external usenet poster
  
Posts: 1
Default Finding values within an array

Is there a neater/faster way than having to use worksheet functions and
iterating through an array to find values.

my example - I have an array containing the following:
AAAA ZZ 0001
BBBB ZZ 0001
AAAA XX 0001
BBBB ZZ 0001
AAAA XX 0001

I'm aiming to search for 'AAAA' and 'XX' which would return a subtotal
of 2.
If this needs more explain - give a shout.
Cheers,
Matt.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=526723

Reply With QuoteReply With Quote