DynamicFilteredListsQ28356442.xlsx

<div>
Thanks NBVC and byundt for your answers.<br />
<br />
I ended up splitting the data on 2 different sheets. <br />
<br />
Thanks again for your time.<br />
<br />
Regards.
</div>


Thanks NBVC and byundt for your answers.

I ended up splitting the data on 2 different sheets.

Thanks again for your time.

Regards.

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
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.<br />
<br />
Daily &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1<br />
Daily &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2<br />
Monthly &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1<br />
Daily &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3<br />
Monthly &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2<br />
<br />
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. <br />
<br />
Do you think this is doable?<br />
<br />
Thank you for your time.
</div>
</div>


Hello Experts,

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.

Daily	1
Daily	2
Monthly	1
Daily	3
Monthly	2

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.

Define Dynamic Excel Range Based on Column in Unsorted data set

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.