If Excel is showing formulas instead of results on your Windows PC, check the cell format, turn off the 'Show Formulas' ...
LAMBDA defines the custom logic, and SCAN moves that logic through your data range.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback