Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
i want to create a report in excel 2007 that allows me to allocate a 'group' (embedded in the formula) in a single column how old a particular line on a purchase order is. Here is some sample data with the expected results; PO Age 91 30 -4 52 the groups a Future (less than zero, 0-30,31-60,61-90,90+) Expected Results: PO Age AGE 91 90+ 30 0-30 -4 FUTURE 52 31-60 THANKS in advance!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a purchase order log in Excel? | Excel Discussion (Misc queries) | |||
Aging - show net due in oldest age category | Excel Discussion (Misc queries) | |||
Pivot table aging report sort order | Excel Worksheet Functions | |||
How do I have calculation responses viewed in a Purchase Order? | Excel Worksheet Functions | |||
purchase order counter in excel purchase order template | Excel Worksheet Functions |