G
Guest
I am trying to reconcile to accounts. I need to sort both sets of data to
each corresponding numbers.
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
----------------------------------------------------------------------------
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------
G
Guest
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
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