brennermac
New Member
- Joined
- Jul 7, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello,
I am working on a spreadsheet that contains monthly financial data for a company over the past five years. I am grouping similar months together, i.e. January 2016-January 2020, and was wondering if it is possible to have a drop down list that contains all the months to allow for easier searching. For example, if I wanted to view the financial data for the month of January over the past five years, could I select January from a list and have only that data appear?
Let me know if I can provide any further clarification. Thanks!
I am working on a spreadsheet that contains monthly financial data for a company over the past five years. I am grouping similar months together, i.e. January 2016-January 2020, and was wondering if it is possible to have a drop down list that contains all the months to allow for easier searching. For example, if I wanted to view the financial data for the month of January over the past five years, could I select January from a list and have only that data appear?
Let me know if I can provide any further clarification. Thanks!