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