Dear All,
I do have the following sample data set across A1:F4.
<colgroup><col span="4"><col><col></colgroup><tbody>
Site
SKU
Qty
Date
Maximum Qty
Maximum Qty Date
a
1
10
01-Oct
35
10-10-2019
a
1
35
10-Oct
35
10-10-2019
a
1
25
24-Oct
35
10-10-2019
</tbody>
In column E the formulae is...