Now only the last part, which is the most important part needs to solve.
With Glenn's ISNUMBER() function, we'll able to get this..
Attachment 498943
But what I want is to have the hours pointed to the correct "Headers" of that table. Which the final result should look like this.
Attachment 498944
Now Glenn's improvement gave me a new idea, is there a function I can put in the ROW that will search the same HOURS that matches the HEADERS & put a 1's value in cell?
Bookmarks