The UsedArray is always a subset of the TotArray
The difference between TotArray and UsedArray will always go into AvailArray
There are never duplicates in any of the arrays
The TotArray is organized by number in ascending order
( the original example shows cars, but the actual data is a text field
of numbers) - never more than 8
TotArray
411310
411320
411330
411340
411350
411360

The items in the UsedArray may not be contiguous - for example
UsedArray
411320
411340
411360

GMet

"pikus" wrote in message
...

Will UsedArray always be the same up to a point as TotArray? As in, will
the difference always be because one is longer than the other?

Do you only want to compare the items with the same index number or do
you want to know if the value is matched anywhere at all in the other
array?

Are the arrays organized in some useful way?

Is it possiblethat you would have dupliate entries in one array and if
so, assuming the value is found only once in the other array, should
the value be added to your new array?

Would I be correct in assuming that the UsedArray only contains values
from the TotArray?

Thanks - pikus


--
pikus

I have two kids. :-)
------------------------------------------------------------------------
pikus's Profile:
http://www.excelforum.com/member.php...fo&userid=3550
View this thread: http://www.excelforum.com/showthread...hreadid=264223