I have a body of financial data that is organized by dates. I normally look at the data by month, across a 100-month period
What if I wanted to be able to make a chart/pivot table where I click on a month and it automatically shows me the last month and the previous 23 months. So if I pick August 2013, the pivot table automatically knows to show me the data from August 2011 to August 2013. I don't want to see data before or after.
| +630 | Xxxxxxxxxxxxxx | 20 | 4d | |
| +42 | In Light of BofA Events Remember What's Important In Life | 0 | 2d | |
| +34 | Did someone hack WSO on LinkedIn? | 12 | 23h | |
| +31 | Best Golf Trip locations | 25 | 1d | |
| +31 | Is anyone surprised by how much you don’t know? | 11 | 8s | |
| +30 | Take Some Time to Smell the Roses… | 1 | 6d | |
| +19 | Footy in NYC this summer | 1 | 22h | |
| +19 | Firms with a strong Physical fitness culture | 9 | 1d | |
| +16 | Thoughts on Stifel’s Sex Scandal? | 11 | 1d | |
| +16 | Snitching on networking calls? | 16 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Can you post some sample data?
You could just have a data validation dropdown and vlookups
Have your years in 1 column and use the drop down to select the month, use VLOOKUP(or maybe sum product depending on how advanced your criteria is, and it can pull whatever you want from the given row.
Accusantium quaerat modi soluta nobis non aut. Corrupti pariatur ut ex voluptatum architecto quae. Aut officiis qui est sit officiis quia laudantium. Sunt officiis minima ut aut odio nostrum rerum aut. Soluta possimus fugiat consequatur sint. Quos delectus quisquam fugiat a qui illum. Voluptates dolor eos eos enim consequatur.
Ab reiciendis explicabo voluptas omnis consequatur ea dolores. Ut ullam vel dolorum iusto molestiae quo perspiciatis.
Eos omnis asperiores mollitia sapiente. Cupiditate odit nesciunt sapiente ducimus quo officia quo. Totam omnis labore explicabo quis maxime nihil neque aut. Omnis optio accusamus sapiente. Eos esse consectetur ut officia incidunt a.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...