View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ajmister ajmister is offline
external usenet poster
 
Posts: 6
Default comparing two fields in an excel spreadsheet

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