I am having hard time trying to work this out. Maybe there is no simple solution for this. I have data in the following format.
I want to define 2 ranges which will select data based on first column. So a range named Daily will only select rows where the value in the first column is Daily. I can do it if the data is sorted but that is not going to be the case always.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.