Forum Discussion
Solved
Calculating annual (& YTD) account credits from a dated record of monthly credits
Hi...Been struggling to solve the following problem with Excel 365 and hoping someone can help. Here is a summary. Thanks in advance for any help and suggestions. Fraser. There 20 different accou...
Hi PhraserB
EDIT: After clarifications below proposal does not apply. Approach could apply to other scenario though
Alternatively Unpivot your accounts with Get & Transform aka Power Query (sample attached). After that almost all analysis are easy, i.e. with a PivotTable:
- Hi Lz.... Many thanks for taking time to reply and for recommending using a Pivot Table. I realise and apologise that I have not explained the problem clearly enough. Please see my reply to Quadruple Pawn which gives further information. Thanks again for your help. Fraser
