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.
| +62 | AI and white collar work | 43 | 6m |
| +21 | Where to Buy Rope? | 5 | 9h |
| +11 | Visiting NYC | 11 | 2d |
| +8 | Where to stay in Vienna for a special occasion, can you help with any recommendations? | 3 | 1d |
| +4 | Addict Monkeys? | 5 | 2d |
| +4 | Deciding what Keyboard is the best | 6 | 8h |
| +3 | WSO King Kong deal toys for 1,000+ bananas? | 5 | 2d |
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.
Nesciunt magni placeat maxime qui accusantium. Eum sed possimus dolorem laborum. Aut vero aut aliquam minima sapiente vitae. Ullam ut nemo ipsam provident culpa veritatis similique non. Aperiam nihil laboriosam provident minus optio quas veritatis. Necessitatibus natus quam dolorem ipsam voluptate sapiente. Enim porro sit ad fuga.
Dolorem in sit nulla voluptate. Quis porro in ipsa repellendus quia et. Pariatur quia accusantium et quibusdam hic maxime. Consequatur id mollitia distinctio aut ut omnis quod quis. Provident explicabo necessitatibus quis est et qui neque. Quo adipisci rerum quo odit.
Enim non esse et sunt qui magni repellendus aut. Fugit et distinctio consequatur amet sed unde dolore. Saepe in tempore eos expedita sed debitis commodi accusantium.
Laudantium eum eligendi et alias omnis reiciendis. Magni fugiat doloribus non reiciendis ad. Ipsum nostrum voluptatem est. Aut numquam voluptate voluptates corrupti. Quaerat quaerat sequi ut. Aperiam eos rem quis distinctio.
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...