Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding values within an array
Beyond worksheet functions, there are no VBA functions that would do what you
want. That said, looping through an array is very fast. the only function I can think of that comes close to working with an array is the Filter function, but it only works on a one dimensional array of strings. -- Regards, Tom Ogilvy "MattShoreson" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a series of values within an Array | Excel Programming | |||
Finding a series of values within an Array | Excel Programming | |||
Finding a series of values within an Array | Excel Programming | |||
Finding a series of values within an Array | Excel Programming | |||
Need help finding unique values and transforming an n x 1 Array | Excel Programming |