I have data showing current years data by month as well as the previous years data
I have set up a drop down list for the current year as well as formulas so that when the month and year is selected then the applicable data is displayed
I also want to display the previous month and year data , but only want a drop list for the month and year for the current years data. When the drop down list is selected , then the month and year pertaining to the previous year must be displayed
for eg if I select Feb-20 then Feb-19 data to be displayed as well , without have to have two drop down lists
I have attached sample data
It would be appreciated if someone could kindly assist me
Bookmarks