In block c6 to c9 I have one date,
In block e6 to e9 the total is 8.
In block f6 to f9 I am looking for one of three codes.
What formula do you use when you need to look at c6 to c9 for the date.
look at e6 to e9 for the hours to total 8.
look for one of the three codes in the same blocks, for only one block.
I tried countif and it did not help. Anymore ideas.
I can e-mail a part copy of the project I am working on, to see if you all can improve on my personal project.
In block e6 to e9 the total is 8.
In block f6 to f9 I am looking for one of three codes.
What formula do you use when you need to look at c6 to c9 for the date.
look at e6 to e9 for the hours to total 8.
look for one of the three codes in the same blocks, for only one block.
I tried countif and it did not help. Anymore ideas.
I can e-mail a part copy of the project I am working on, to see if you all can improve on my personal project.