Forum Discussion
Is it possible to nest filter inside of sumif?
Office 365 without Lamda functionality I have a large data set (1000+ rows with 100+ columns) Below screen shot is a scaled-down version of the data set but I think it serves a good example. ...
Hello Lorenzo
I do not have a version of Office 65 with Let function and I have no option to get it (Semi annual enterprise channel license)
While this approach would work great if I did have let/lambda features, could you do it without them?
I do not have a version of Office 65 with Let function and I have no option to get it (Semi annual enterprise channel license)
While this approach would work great if I did have let/lambda features, could you do it without them?
With an Helper sheet (can be hidden) then. See attached file where I named your 3 inputs/parameters + the dynamic arrays that sit in the helper sheet