| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Aging by netting negatives in other age buckets for the customer
Have a customer line items database. Have put an IF formula to generate a TAG
column for AGING BUCKET using if(date(2009,3,31)-A2<=30,"Current".... When I run a pivot on this AGING BUCKET as the column object with customer no as the row object, i get an aging report which has unbalanced NEGATIVES in the current bucket (signifying the COLLECTION recd against an invoice) with the INVOICES getting stacked up as huge POSITIVES in the older age buckets. Require a formula or VBA Code to get excel to netoff credits with debits for a customer and give me a correct aging ... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to put data into different buckets. - PLEASE HELP | Excel Discussion (Misc queries) | |||
| Netting off | Excel Discussion (Misc queries) | |||
| Allocating usage across aging buckets | Excel Worksheet Functions | |||
| CONVER CSV CUSTOMER DATA TO A CUSTOM INDIVI CUSTOMER PRICE SHEET | Excel Discussion (Misc queries) | |||
| Netting off to zero | Excel Worksheet Functions | |||
Threaded Mode
