The visibility rule: Excel only says what it can see. If you use filters to hide specific rows, Excel skips over them ...
Learn how GROUPBY passes both subset and full arrays into LAMBDA in Excel, letting you compute percent shares fast and explain results clearly.
If Word, Excel, PowerPoint automatically reset settings on exit, follow these instructions e.g. check folder and Reigtsry ...