Question

Sort the selected cells by Time to Reorder? (in Z to A order) and then Quantity in Reorder (Smallest to Largest)

Answer 1

To sort selected cells first by 'Time to Reorder' in Z to A order and then by 'Quantity in Reorder' from Smallest to Largest, use the sorting feature in your spreadsheet program, apply the primary sort, and then add the secondary sorting level.

Step-by-step explanation:

The question asks how to sort selected cells in a spreadsheet based on two criteria: first by the Time to Reorder in descending order (Z to A), and then by the Quantity in Reorder in ascending order (Smallest to Largest). To accomplish this sorting:

1. Select the range of cells that contain the data you want to sort.
2. Access the sorting feature in your spreadsheet program (this is often found under the 'Data' tab).
3. Apply the first sort by 'Time to Reorder' in descending order. This will organize the data with the longest times at the top.
4. Without altering the current sort, apply a secondary sort by 'Quantity in Reorder' in ascending order. This will sort the rows with the same 'Time to Reorder' by the quantities, from smallest to largest within each time group.

If you're using a program like Microsoft Excel, the secondary sort can usually be added by clicking 'Add Level' in the sort dialog box. Make sure to check if your data has headers and select the appropriate sorting options.