Hi
I frequently come accross this situation and I was wondering if there is an easy way to do this. I can do this in Access but not in excel, here is the problem:
In "sheet 1"Column A" I have Jon, Albert, Tim and "Column B" I have 1,2,3; in "Sheet 2" "Column A" I have Tim, Albert, Sam and "Column B" I have 4,5,6.
Sheet 1:
A B
Jon 1
Albert 2
Tim 3
Sheet 2:
A B
Tim 4
Albert 5
Sam 6
My question is is there a formula or an "Excel query" that I can run where in Sheet 3 it will take the Match of Sheet 2 substract Sheet 1 and then include all the non match of the two sheets, like below.
Sheet 3
A B
Jon 1
Albert 3
Tim 1
Sam 6
Thanks in advance.
I frequently come accross this situation and I was wondering if there is an easy way to do this. I can do this in Access but not in excel, here is the problem:
In "sheet 1"Column A" I have Jon, Albert, Tim and "Column B" I have 1,2,3; in "Sheet 2" "Column A" I have Tim, Albert, Sam and "Column B" I have 4,5,6.
Sheet 1:
A B
Jon 1
Albert 2
Tim 3
Sheet 2:
A B
Tim 4
Albert 5
Sam 6
My question is is there a formula or an "Excel query" that I can run where in Sheet 3 it will take the Match of Sheet 2 substract Sheet 1 and then include all the non match of the two sheets, like below.
Sheet 3
A B
Jon 1
Albert 3
Tim 1
Sam 6
Thanks in advance.