Use dates in data to create filter

[markgraham123]

Hi all,

I have available stock of 16 for Item 'A'.

But req. is 26.

Now i want to allocate that 16 to the oldest deadline IDs.

In this case, i want to allocate available 16 to the IDs till deadline 7/22 as they are close by- since it counts to 15.

ID	Deadline	ITEM	Req.	Avail.
1	7/10/2017	A	1.00	16.00
2	7/12/2017	A	1.00	16.00
3	7/15/2017	A	1.00	16.00
4	7/15/2017	A	1.00	16.00
5	7/15/2017	A	1.00	16.00
6	7/18/2017	A	1.00	16.00
7	7/18/2017	A	1.00	16.00
8	7/18/2017	A	1.00	16.00
9	7/19/2017	A	1.00	16.00
10	7/19/2017	A	1.00	16.00
11	7/20/2017	A	1.00	16.00
12	7/21/2017	A	1.00	16.00
13	7/21/2017	A	1.00	16.00
14	7/21/2017	A	1.00	16.00
15	7/22/2017	A	1.00	16.00
16	7/24/2017	A	2.00	16.00
17	7/24/2017	A	2.00	16.00
18	7/24/2017	A	1.00	16.00
19	7/24/2017	A	1.00	16.00
20	7/25/2017	A	2.00	16.00
21	7/25/2017	A	1.00	16.00
22	7/25/2017	A	1.00	16.00
23	7/26/2017	A	2.00	16.00
24	7/28/2017	A	1.00	16.00
25	7/29/2017	A	1.00	16.00
26	8/2/2017	A	1.00	16.00

Any help is highly appreciated!!

Please see the attachment

[markgraham123]

Trying the second condition brother!

Let me try.

[sunny_talwar]

I think so... and that is why I started with ITEM and then Deadline. Not sure if you need to sort by ID when Deadline is the same?

[markgraham123]

Thanks a lot brother!