Hi,
I need to make a GANTT schedule from the production with tanks etc. I cannot get the different formulas to work, when they do I will add it as conditional formatting in different colours.
=IF(AND($C2=Raw!$H:$H;D$1>=Raw!$E:$E;D$1<=Raw!$G:$G);1;0)
Then I can get some TRUE values in one area on different rows, but wrong.
I tried to used this formula from an old thread, but without success, maybe I missed something. Please help!
I need to make a GANTT schedule from the production with tanks etc. I cannot get the different formulas to work, when they do I will add it as conditional formatting in different colours.
- In D2 "Gannt Mrexcel.jpg" I want TRUE if C2 find a match in H:H "Raw data Mrexcel.jpg", also the date and time in D1 must be equal or between E:E and G:G in "Raw data Mrexcel.jpg"
- Then I want to index this I:I value into D2.
- Then I want to drag the formula vertical and horizontal.
=IF(AND($C2=Raw!$H:$H;D$1>=Raw!$E:$E;D$1<=Raw!$G:$G);1;0)
Then I can get some TRUE values in one area on different rows, but wrong.
I tried to used this formula from an old thread, but without success, maybe I missed something. Please help!