O
Odawg
Hello All Excel Guru's:
I was wondering if it was possible to have a macro to compare two
columns of data and in the third column only show the ones that are in
Column B and not in Column A and vice versa, In Column A but not in
Column B in Column D
Examle:
Column A Column B Column C Column D
Apple Apple
Bananas Bananas Strawberry
Orange Pear Pear
Grapes Orange Cherry
Strawberry Grapes
Cherry Plums Plums
I have a formula that does this, but I have to copy this formula down
Column C. The
formula that I have is listed below:
formula located in Column C
=IF(B3:B101="","",IF(ISERROR(VLOOKUP(B3,$A$1:$A$2000,1,FALSE)),B3,""))
formula located in Column D
=IF(A3:A101="","",IF(ISERROR(VLOOKUP(A3,$B$1:$B$2000,1,FALSE)),A3,""))
Is there anyway to have a macro do the same thing, except that have
all the items in column C and column D sorted together?
Any and all help in this matter is greaty appreciated.
Argus
I was wondering if it was possible to have a macro to compare two
columns of data and in the third column only show the ones that are in
Column B and not in Column A and vice versa, In Column A but not in
Column B in Column D
Examle:
Column A Column B Column C Column D
Apple Apple
Bananas Bananas Strawberry
Orange Pear Pear
Grapes Orange Cherry
Strawberry Grapes
Cherry Plums Plums
I have a formula that does this, but I have to copy this formula down
Column C. The
formula that I have is listed below:
formula located in Column C
=IF(B3:B101="","",IF(ISERROR(VLOOKUP(B3,$A$1:$A$2000,1,FALSE)),B3,""))
formula located in Column D
=IF(A3:A101="","",IF(ISERROR(VLOOKUP(A3,$B$1:$B$2000,1,FALSE)),A3,""))
Is there anyway to have a macro do the same thing, except that have
all the items in column C and column D sorted together?
Any and all help in this matter is greaty appreciated.
Argus