The Solver add-in for Microsoft Excel is one of the most important, so we can understand the frustrations when users cannot get it to work as they hope. In older versions of Excel, folks had to ...

Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.

Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.