SOLVER

1.Click the File tab, and then click Options.
2.Click Add-Ins, and then in the Manage box, select Excel Add-ins.
3.Click Go.
4.In the Add-Ins available box, select the Solver Add-in check box, and then click OK.
1.Tip If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in.
2.If you get prompted that the Solver add-in is not currently installed on your computer, click Yes to install it.
5.After you load the Solver add-in, the Solver command is available in the Analysis group on the Data tab.