How to filter through multiple “Arrays” at once?

I am attempting to write a sub that'll go through the two given arrays, "customers who purchased last year" and "customers who purchased this year" and create THREE arrays; "who bought last year," "who bought this year," and "bought in either year". Since the two given lists have names who bought in both years, I am struggling to differentiate between the two into separate arrays. So far the Code successfully achieves the array "bought in either/both years," yet I'm unable to achieve the other 2 and separate. Any advice on where I'm going wrong would be greatly appreciated. Thank you!

Please Login or Register  to view this content.

Hi Dan

Thank you so much for the reply, I tried to include your code and run it, but it gives me an error on "ReDim Preserve list4(listSize4) As Variant". the error reads "Can't change data types of array elements". Also could you please explain what does "GoTo 200" and "GoTo 100" mean in your code as I'm unable to understand it.

Thanks
Vedant

It is giving the error because I had it defined as Variant rather than a String. I edited the code I posted so the arrays are defined as Strings.

The goto 100 line is in the portion of the code when it is populating the only last year array. It is checking list1 against list2 and if the value in list1 matches the value in list2, then it skips to the next value in list1. If none of the values in list2 match list1, then it puts the value of list1 in list4.

The goto 200 line is in the portion of the code when it is populating the only this year array. If the value of list2 in in list1, then it skips to the next value of list2 by going to line 200.

It is giving the error because I had it defined as Variant rather than a String. I edited the code I posted so the arrays are defined as Strings.

The goto 100 line is in the portion of the code when it is populating the only last year array. It is checking list1 against list2 and if the value in list1 matches the value in list2, then it skips to the next value in list1. If none of the values in list2 match list1, then it puts the value of list1 in list4.

The goto 200 line is in the portion of the code when it is populating the only this year array. If the value of list2 in in list1, then it skips to the next value of list2 by going to line 200.