A
ajmister
Hi
I have a spreadsheet which has two fields
Col A Col B
ABC ABC
EFG KLM
KLM MNO
MNO PQR
STU
PQR XYZ
Is there a way in excel to compare the two columns and create an output
like
Col A Col B
ABC ABC
EFG
KLM KLM
MNO MNO
PQR PQR
STU
XYZ XYZ
Thank
Aj
I have a spreadsheet which has two fields
Col A Col B
ABC ABC
EFG KLM
KLM MNO
MNO PQR
STU
PQR XYZ
Is there a way in excel to compare the two columns and create an output
like
Col A Col B
ABC ABC
EFG
KLM KLM
MNO MNO
PQR PQR
STU
XYZ XYZ
Thank
Aj