How to sort to sets of data so that corresponding numbers match

J

Jason

I am trying to reconcile to accounts. I need to sort both sets of data to
each corresponding numbers.
 
K

Ken Wright

Need to be a bit more specific, and example data would help.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
J

Jason

I have two lists of data. One from the General Ledger and one from the
department. When I sort on list of data then sort the other list of data the
data is not sorted in the same way. I am sorting by the column with the
account number and in ascending order. I would assume if both sets of data
were sorted the same way the numbers would appear in the same order.

The lists looks like this:

Account Number Amount Account Number Amount
123456 $100 654321 $150
123457 $150 654320 $100
 
Top