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...

excel

Formulas and Functions

training

SergeiBaklan
Feb 17, 2021
alexanderjaml

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)

Forum Discussion

how to inter formula in a cell has more 8192 characters

Resources