Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Data
I have data imported from Excel to Access. The data is simply a record of
transactions. Many payments belong to one account. I need to sort out the accounts with outstanding balance. However, I cannot exclude the "pay in full" transactions to accomplish my purpose because many other partial payment records which belong to the same "pay in full" account will still remain in the sorting outcome. Do I need to have the data of same account merged together? How do I do the merging? Or is there some other ways? Such as I should set up certain kind of table? These data needs to be updated daily from an Excel book. How should I update the data to accomplish my purpose? I will deeply appreciate the help. Thank you, Linda |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Data
Hi, Linda-
Why not include the "paid in full" transactions? For a given customer if you consider all the charges and all the payments, the paid-in- fulls will simply "wash" (net to a zero sum), and the difference between total charges and total payments is the amount outstanding. I think you'll be doing yourself a favor to include all transactions. And if you ever need to create a statement type of report, you'll have the data on hand already. Just another $0.02~ DaveO Eschew obfuscation |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data | Excel Worksheet Functions | |||
Sorting data within the same row. | Excel Worksheet Functions | |||
Sorting data to match existing data | Excel Discussion (Misc queries) | |||
Sorting Data | New Users to Excel | |||
colors of bar charted data don't follow data after sorting | Charts and Charting in Excel |