List differences between two arrays

[lostest]

I have two columns, column A and column B. All column B values are contained in column A, but not all column A values exist in column B. I want to list the differences in say, column C. Also the values may be repeating.

Lets say my column A values are: A, A, A, B, B, B, C, C, D, D, D, E

column B values are: A, B, D

column C values would then be: C, E

How do I create a macro or formula to produce column C?

[jindon]

Assuming data starts from A1

Please Login or Register  to view this content.

[lostest]

I think I need some more help to adjust your code for my workbook.

Let's assume "Column A" is located on a sheet named "DATA", the the actual data starts in cell B2, now let's assume "Column B" is located on a sheet named "CODES", and the actual data starts in cell D2. Now also lets assume I want the newly identified values to be placed starting on cell P2 on that "CODES" sheet.

Is this doable?

[jindon]

Upload a workbook showing exactly what you have and the result you expect.

[lostest]

The "manual" flow of this task is to take the unique values of column B on sheet DATA, from them take out the values of column B on sheet CODES, and place the difference in column P of sheet CODES. Duplicate values will almost always exists on column B on sheet DATA, but the values on sheet CODES will always be unique.

Does this make sense?

Thank you.

[lostest]

Attachment

[EduardoHiguchi]

Hi lostest!. Try this in the file you have just uploaded, and please tell me if it works in your PC or not

Please Login or Register  to view this content.

[lostest]

Eduardo that works pretty good.

Since I can't quite grasp your code completely I just want to note two things.

The amount of data on the DATA sheet is over 20,000 - meaning I have over 20,000 rows. The amount of data on the CODES sheet, column B is into the several hundreds. To fix this I just changed your "B100" to "B100000".

Also column P on sheet CODES should be completely cleared each time the code is run, otherwise any changes made to the columns B data will NOT show up, assuming said data is NOT overwritten by the possible new differences.

To fix this I just inserted...

Please Login or Register  to view this content.

...at the beginning of your code.

Is my code an efficient way to handle these two points?

[EduardoHiguchi]

----------------------------------------------------------

[EduardoHiguchi]

Yes, the modifications you have done are OK! However, i would not put this code at the beginning of the code

Please Login or Register  to view this content.

i would put it just after the following code

Please Login or Register  to view this content.

that already exists in the middle of the code i submitted you. I want to ask you a favour, could you please mark this thread as solved?
Additionally also if you think that i helped you solve the thread please kindly "pay me" by adding reputation to my post. Have a nice day!

[lostest]

Absolutely. Thank you very much.

Your help will save me a lot of time, and even more frustration.

[lostest]

One last thing,

If all the unique values in column B sheet DATA are contained in column B sheet CODES, and there are no values to be placed in column P a run time error pops up.

Specifically this codes is highlighted,

Please Login or Register  to view this content.

[EduardoHiguchi]

Modify the last part of the code with the following:

Please Login or Register  to view this content.

[jindon]

Try one of 2

Please Login or Register  to view this content.

[lostest]

Thanks Jindon.