Combine arrays

Hi,

I have 4 worksheets. On each worksheet there is one column of data that i am interested in. Each of teh cols has a different header but they contain the same type of data. In this case the data is Lot-ID.

What i want to do is combine all 4 cols into a single array and then using this array come up with a unique list of Lot-IDs. I know how to assign a single col to an array but i am not sure the best way to take 4 cols from 4 different worksheets and put them all into a single array.

any thoughts?

very interesting..........i had not even considered this approach at all. Let me take a look at this..........not familiar with some of this so let me review.........looks like it will work. let me take a look at it. thanks.

finally getting around to looking at this more. Had some other things come up but now i am going to work on this. I did have one question and if its not easy i will try and figure out a way myself.

So i mentioned i had 4 worksheets and i have one col of data from each of the 4 worksheets and that i was trying to get a unique list of the combined 4 cols. Well, i am but i just learned that its really two cols per worksheet......for a total of 8 cols.

So for example: I have Person-ID and Lot-ID as the two cols in each file and i am trying to find the unique list of (Person-ID + Lot-ID) ........not just Lot-ID as i mentioned before.

So using the code i am not sure how yet but i guess i need to combine the two cols into one and then use the code provided then some how "de-couple" the finalized unique col into two cols.......

cool! i will try it out now.........many many thanks!!!!!!!!!!!!

i cant seem to get the remove duplicates part to work correctly.

Recall that i have two columns (Person-ID and Lot-ID).

So i want only unique combinations of PersonID and LotID. FYI: PersonID is in colA and LotID in colB.

What its giving me is the unique entries for colB only.

i am enclosing a test file...............run the macro ......only the unique entries in col B are whats left after you run the macro.

As it turns on in the example i provided.........i think every entry such that the combination of ColA+ColB is a unique entry in the list.

anyone still there?

i dont think using this removeduplicates is going to work as hoped. I could create a 3rd column of values which is a concatenation of the first 2 and then remove duplicates based on this 3rd column......but at that point is it better just to put everything into arrays and do it via arrays?