12-30-2020 12:05 PM
01-01-2021 08:08 AM
Thank you for your reply, but I wanted to know that, I have got the "Earliest expiry date" by the function =MIN(J3,G3,D3) ...now I want the related batch number which is adjacent to that date in the last cell which is "Batch Number of the earliest expiry" for example
Here the Expiry Date(Earliest) is 29-09-2011 which I have got by the function =MIN(J3,G3,D3), now I want the batch Batch Number of the earliest expiry which is "MAT", in the below example in the last column, I have marked "?" question mark for your convenience in the below example.
I would be glad if you kindly provide me a solution.
|Expiry date||batch number||Buffer||Expiry date||batch number||Amount purchased||Expiry date||batch Number||Cost||Stock dispensed to daily dispensing unit||expiry date||Balance in hand||Expiry date (earliest)||batch number of the earliest expiry|