Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
monthly data discrepancies
I do a monthly revenue report; salespeople are paid monthly by Customer ID.
New month's data is added/imported from a text file. I do a report of new month "customer ID's added" and "customer ID's dropped". Presently I sort by customer ID and bill month and do this visually. Does anyone know how I can have excel do this process . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare Two Excel Workbooks & Display Discrepancies | Excel Discussion (Misc queries) | |||
Totalling discrepancies | New Users to Excel | |||
How do I set up monthly random work schedule for 60 hours monthly | Excel Discussion (Misc queries) | |||
Find Discrepancies between Worksheets | Excel Discussion (Misc queries) | |||
Mortgage template comparing interest pd, monthly, bi-monthly, ext. | Excel Discussion (Misc queries) |