Hi All
I need a formula. Here is a sample data
<tbody>
</tbody>
Give oldest date from column A against po number 308211 where the value >0 in Last Column
If Po # is 308211.... Answer should be 4-Oct-18. Coz there are no values in column C
for dates 1st-Oct-18 to 3rd Oct-18
Similarly
If Po # is 301675.... Answer should be 27-Oct-18
Hope anyone can provide a solution
Regards,
Humayun
I need a formula. Here is a sample data
DATE | P.O. # | Value |
1-Oct-18 | 308211 | - |
2-Oct-18 | 308211 | - |
3-Oct-18 | 308211 | - |
4-Oct-18 | 308211 | 21,085 |
8-Oct-18 | 308211 | - |
9-Oct-18 | 308211 | 282 |
11-Oct-18 | 308211 | 16,607 |
20-Oct-18 | 301675 | - |
23-Oct-18 | 301675 | - |
24-Oct-18 | 301675 | - |
25-Oct-18 | 301675 | - |
26-Oct-18 | 301675 | - |
27-Oct-18 | 301675 | 1,522 |
29-Oct-18 | 301675 | - |
30-Oct-18 | 301675 | - |
1-Nov-18 | 301675 | - |
5-Nov-18 | 301675 | 9,211 |
7-Nov-18 | 301675 | 14,080 |
<tbody>
</tbody>
Give oldest date from column A against po number 308211 where the value >0 in Last Column
If Po # is 308211.... Answer should be 4-Oct-18. Coz there are no values in column C
for dates 1st-Oct-18 to 3rd Oct-18
Similarly
If Po # is 301675.... Answer should be 27-Oct-18
Hope anyone can provide a solution
Regards,
Humayun