| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Group data by UK financial years
Hi Group,
I have hundreds of rows of data. I would like to group the data by UK financial year (01 Apil - 31 Mar) to obtain totals by releavnt years. Can someone suggest a way forward? I have tried pivot tables but Excel says it cannot group on that data. Ideally, I would like to end up with something like the following: Year Total Payments 01/04/2002 - 31/03/2003 £79,557.25 01/04/2003 - 31/03/2004 £244,728.69 01/04/2004 - 31/03/2005 £450,063.19 01/04/2005 - 31/03/2006 £5,000.00 Many thanks Tony |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy drag financial years | Excel Worksheet Functions | |||
| Copy Paste Financial Years | Excel Worksheet Functions | |||
| Group Excel data in varying length financial periods 4/5 weeks | Excel Discussion (Misc queries) | |||
| Financial Years | Excel Discussion (Misc queries) | |||
| year function and financial years | Excel Worksheet Functions | |||
Threaded Mode
