News
This column shows how to use the Data Table option in Excel’s What-If Analysis tool.
How-To Geek on MSN3d
How to Use the SORT and SORTBY Functions in Microsoft Excel
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.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback