Define Dynamic Excel Range Based on Column in Unsorted data set
Posted on 2014-02-04
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.
Do you think this is doable?
Thank you for your time.