Sort the Participants table first on the Workshop field in ascending (A to Z) alphabetical order, and then on the Rating field in descending (Largest to Smallest) numerical order. How to do in excel
To sort the Participants table in Excel based on the Workshop field in ascending alphabetical order and then on the Rating field in descending numerical order, you can follow these steps:
1. Select the range of cells that contains the Participants table.
2. Click on the "Data" tab in the Excel ribbon.
3. Click on the "Sort A to Z" button in the "Sort & Filter" group to sort the table based on the Workshop field in ascending alphabetical order.
4. After the table is sorted alphabetically by the Workshop field, click on the header of the Rating column to select the entire column.
5. Click on the "Sort Z to A" button in the "Sort & Filter" group to sort the table based on the Rating field in descending numerical order.
By following these steps, you will have the Participants table sorted first on the Workshop field in ascending alphabetical order, and then on the Rating field in descending numerical order.