| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rolling Monthly Amounts to Annual Monthly Amounts
I have a spreadsheet that reports sales on a rolling monthly basis: Aug 2005 - Jul 2006 this month, Sept 2005 - Aug 2006 the next month, and so on. I need to create a annual report by Jan - Dec using the rolling monthly data each month. Want to enter amounts into the rolling monthly report and have the same information on the annual report. Is this done by a VLOOKUP function? What formula would I use? Need to help!!! -- RV |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the IRR formula for MONTHLY periodic payments? | Excel Worksheet Functions | |||
| bank cal for interest on cd | Excel Worksheet Functions | |||
| IRR calc Monthly vs Annual | Excel Worksheet Functions | |||
| How do I forecast monthly and annual totals from previous year's . | Excel Worksheet Functions | |||
| Z Chart i.e. top rolling annual bottom rolling monthly middle cum. | Excel Worksheet Functions | |||
Linear Mode
