Hi,
I have a list of products and associated dates. A product will have multiple materials and each material have a expiry date. Something like table below.
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
I want to run a query where say I want to look for product 'AA' and say its expiry date. For example 'AA' has material 'd' whose expiry date is 21-Feb-20. So for query for expiry of product AA, I should get the earliest of all dates, in this case 21-Feb-20.
Could you please help with the excel formula to find this out?
Regards
Soumen
I have a list of products and associated dates. A product will have multiple materials and each material have a expiry date. Something like table below.
| Product | Material | Material Expiry |
| AA | a | 16-Aug-23 |
| AA | b | 17-May-23 |
| BB | b | 18-Aug-25 |
| AA | c | 19-Aug-22 |
| CC | b | 20-Aug-26 |
| AA | d | 21-Feb-20 |
| BB | a | 22-Aug-24 |
| CC | a | 23-Dec-19 |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
I want to run a query where say I want to look for product 'AA' and say its expiry date. For example 'AA' has material 'd' whose expiry date is 21-Feb-20. So for query for expiry of product AA, I should get the earliest of all dates, in this case 21-Feb-20.
Could you please help with the excel formula to find this out?
Regards
Soumen
