Forum Discussion
Solved
how to inter formula in a cell has more 8192 characters
hello guys I am using office 2019 I tried to maintain our work activity progress in the project by making a tracking plane depending on the entry data we have provided it in another sheet table fo...
Here are two different questions
1) how to highlight some cells
2) how to apply the formula in sample
First question - didn't catch the logic, not sure
Second question - use alternative formula which returns desired result. It could be
=--(SUMPRODUCT( (A$1>=Bedding!$A$1:A$100)*(A$1<=Bedding!$B$1:B$100))>0)
alexanderjaml Can you disclose what you have in the BEDDING sheet and what output you expect in the progress chart? I'm pretty sure you don't need such a monstrous formula for whatever you are trying to do.
yeah i find it
thank u so much Riny_van_Eekelen
=--(SUMPRODUCT( (A$1>=Bedding!$A$1:A$100)*(A$1<=Bedding!$B$1:B$100))>0)
