Using What-If Analysis, you can visualize the effects of different variables, making it easier to assess risks and opportunities. In Excel, three primary tools are available for performing What-If ...

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Two-Variable Data Table Setting Up a Two-Variable Data Table: List one set of values horizontally and the other set vertically. Enter the formula above the vertical list of values.

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