When used on another sheet, the formula takes the following shape: But technically, the formula is only in the first cell, and deleting it from D2 will delete all the results.
The results "spill" automatically to as many cells as needed (D2:D10 in our case). Putting the arguments together, we get this formula:įor simplicity, we use the formula on the same sheet - enter it in D2 and press the Enter key.
Supposing, you have a list of projects with the Value field. Here's a typical scenario of using a SORTBY formula in Excel: For the referenced array to expand automatically, convert the source range to an Excel table or create a dynamic named range.
#HOW TO PAGINATE IN EXCEL 2010 UPDATE#
However, new entries that are added outside of the array referenced in the formula are not included in the results unless you update the array reference.