Macros to compare values in two columns and place the duplicates in third column .......

[olutoyin]

I need macro script that will compare values in column a with values in column b,if there are values that are in a but not in b, such values are copied into column c, if there are values in column b that are not in column a, such values are copied to column d and place the duplicates (values in column a that also appear in column b) are copied into column e.

The Code should run from row 2 on all the 5 columns to give allowance for the column titles which will be in the 1st row of each column.

I hope i can get macros that can be used for this. Please any prompt response will be appreciated.

Thanks

 

[Comfy]

Three formulas copied down would do the trick, does it need to be a macro?

 

[Comfy]

Also,

If there were values in A and B but these values did not match would you want to ignore these?

 

[olutoyin]

Thanks comfy, i have tried to use formulas but it was very slow not responding for about 30 minutes because the data on the 2 columns are very bulky.

I will really prefer macros.
Expecting replies.

 

[Comfy]

What would you return for row five?

Excel Workbook
	A	B	C	D	E
2	321		321
3		321321		321321
4	987	987			987
5	321	321321	?	?	?
Sheet1

Excel 2007

 

[olutoyin]

Values in column a on row 2 should not reappear in row 5 since they are the same. Values on each column should be distinct i.e the same values should not reappear in a particular column.

Ideally the value in row 5 column a should not reappear same applies to value in column b row 5.

I hope you understand.

Thanks for your assistance

 

[Comfy]

Ignore that the values are duplicated in the column, its for an example only.

Would row five have and entry in both column C and D?

 

[olutoyin]

Once the conditions are met:

Values in column a but not in column b is placed in column c
values in column b but not in column a is placed in column d
values in column a that are duplicated in column b is placed in column e

results in column c,d and e should start from row 2

 

[Comfy]

Repeating your question does not help. I understand what it is that you require.
You've not answered my question.

your first two statements:

Values in column a but not in column b is placed in column c
values in column b but not in column a is placed in column d

Are the same.

If "a" doesn't equal "b" is the same as If "b" doesn't equal "a"

unless a or b are blanks.

So please answer my question about what you want to happen if both a and b are not blank and are not the same.

Thanks,
/Comfy

 

[olutoyin]

there will not be values in row 5 for columns c and d in the example below