comparing two fields in an excel spreadsheet
Yes, that is correct.
Thank you
Ajay
"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Aj,
Just to be clear, you want to create an alphabetized list in column A that
includes all uniques entries from columns A and B, and then move items in
column B to match the values in column A.....
HTH,
Bernie
MS Excel MVP
"ajmister" wrote in message
...
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
|