Forum Discussion
Complex Excel Formula Help
Hello, I have a complicated excel problem I'm hoping to get some help for. I'm not sure if it's actually possible to solve, but you all are my best chance. Platform: Excel 365 Problem: I h...
By splitting your data in separate sheets for each month you are making analyses like this overly complicated. Data about a single subject should always go in a single table, using dedicated columns that allow you to summarize the data by customer, by product, by period, etcetera. Make sure you format the range "as table". Having done this, start exploring Pivot tables.