Forum Discussion
Need help with Solver or a better option
I am not sure if this can be done in solver or if there is something better to use. I am querying a large data set of golf stats from multiple excel spreadsheet into 1 combined stats spreadsheet ...
See if =Subtotal(… can be used, as it gives you totals (Avg/Max/Min/Sum etc) based on filtered records. If not, see if Pivot Tables will help. Both could be linked to other tabs.