Dear All,
I do have the following sample data set across A1:F4.
<colgroup><col span="4"><col><col></colgroup><tbody>
</tbody>
In column E the formulae is as follows:-
E2=MAX(IF($A$2:$A$4=A2,IF($B$2:$B$4=B2,$C$2:$C$4)))
I am looking for formulae across Column F which can yield the desired result as given above.
Pls help.
Thanks
I do have the following sample data set across A1:F4.
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 |
<colgroup><col span="4"><col><col></colgroup><tbody>
</tbody>
In column E the formulae is as follows:-
E2=MAX(IF($A$2:$A$4=A2,IF($B$2:$B$4=B2,$C$2:$C$4)))
I am looking for formulae across Column F which can yield the desired result as given above.
Pls help.
Thanks