Try:
=LET(A,C7:F1000,B,FILTER(A,INDEX(A,,3)<>0),C,INDEX(B,,1)+INDEX(B,,2),VSTACK(C6:F6,FILTER(B,(C>=N17)*(C<=O17))))
Refer to the file. I may have added some rows/columns...
Try:
=LET(A,C7:F1000,B,FILTER(A,INDEX(A,,3)<>0),C,INDEX(B,,1)+INDEX(B,,2),VSTACK(C6:F6,FILTER(B,(C>=N17)*(C<=O17))))
Refer to the file. I may have added some rows/columns...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
That is great , but to go further, I should have mentioned the drop down and the data validation
Your knowledge is greatly appreciated See attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks