Ideas for a Date Array Scan of Data

NatetheGreat

Active Member
Joined
Nov 18, 2013
Messages
268
Hi there,

I have a series of rows for each date, each row can be any other date, based on the expiration of that item. For example my raw data looks something like below

01/01/2014 data data data 201406
01/01/2014 data data data 201407
01/01/2014 data data data 201408
01/01/2014 data data data 201409
02/01/2014 data data data 201406
02/01/2014 data data data 201407
02/01/2014 data data data 201408

and continues on. I have a key in another sheet telling me which the expiration month row I want for each day, between specific dates i.e.

01012014-19012014 201406
20012014-31012014 201407
etc etc

What I would like to do, is scan through my raw data , and create a new range in a new sheet, that contains only those rows with the expiration months I desire, based on the key.

For example for all rows on each day between 01012014-19012014 I want to only have those rows with 201406 in expiration month column. I would like to do this via a dynamic array rather than a loop and vlookup as the dataset is huge and I would like it to be as quick as possible.

Thanks All

natethegreat
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Watch MrExcel Video

Forum statistics

Threads
1,129,361
Messages
5,635,808
Members
416,884
Latest member
leeshjay

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top