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.
[TABLE="width: 224"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD]Product[/TD]
[TD]Material[/TD]
[TD]Material Expiry[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]a[/TD]
[TD]16-Aug-23[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]b[/TD]
[TD]17-May-23[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]b[/TD]
[TD]18-Aug-25[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]c[/TD]
[TD]19-Aug-22[/TD]
[/TR]
[TR]
[TD]CC[/TD]
[TD]b[/TD]
[TD]20-Aug-26[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]d[/TD]
[TD]21-Feb-20[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]a[/TD]
[TD]22-Aug-24[/TD]
[/TR]
[TR]
[TD]CC[/TD]
[TD]a[/TD]
[TD]23-Dec-19[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 224"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD]Product[/TD]
[TD]Material[/TD]
[TD]Material Expiry[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]a[/TD]
[TD]16-Aug-23[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]b[/TD]
[TD]17-May-23[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]b[/TD]
[TD]18-Aug-25[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]c[/TD]
[TD]19-Aug-22[/TD]
[/TR]
[TR]
[TD]CC[/TD]
[TD]b[/TD]
[TD]20-Aug-26[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]d[/TD]
[TD]21-Feb-20[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]a[/TD]
[TD]22-Aug-24[/TD]
[/TR]
[TR]
[TD]CC[/TD]
[TD]a[/TD]
[TD]23-Dec-19[/TD]
[/TR]
</tbody>[/TABLE]
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