HI,
Good day.
I'm trying to return the date where the planned pieces is less than the capacity/day excluding the Friday.
Please find the attached excel file.
Thanks for your support.
Regards
Muralidaran.
HI,
Good day.
I'm trying to return the date where the planned pieces is less than the capacity/day excluding the Friday.
Please find the attached excel file.
Thanks for your support.
Regards
Muralidaran.
Last edited by muralidaran; 08-24-2017 at 02:59 AM. Reason: SOLVED
Thanks & Regards
Muralidaran.
Thanks, i have solved it with the below array formula.
={MIN(IF(((B5:O5<>B1)*(B6:O6<>"Fri"))>0,B7:O7))}
Regards
Muralidaran
Or,
Try the following array formula in B2:
=INDEX(B7:O7,MATCH(1,(B5:O5<B1)*(B5:O5<>0),0))
confirmed by pressing CTRL+SHIFT+ENTER
Last edited by cbatrody; 08-24-2017 at 03:33 AM.
Thanks, that works fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks