Automatically moving rows in office 365 excel based on rank or largest to smallest of a said column

adstristar 

Based on the provided data, it seems that the column you want to use for ranking is "Column3" (Column C). To populate the rankings in a separate column and sort the rows based on the ranking, you can follow these steps:

1. Insert a new column next to your existing table, where you want to display the ranking. In your case, this would be column D.
2. In cell D2, enter the following formula and drag it down to populate the remaining cells:

=RANK(C2,$C$2:$C$25,0)

This formula ranks the values in Column C (Column3) in descending order (largest to smallest) within the range C2:C25. Adjust the range if your data extends beyond this range.

1. Now, select the entire table, including the headers, and go to the "Data" tab in the Excel ribbon.
2. Click on the "Sort" button in the "Sort & Filter" group.
3. In the "Sort" dialog box, choose the column that contains the rankings (Column D) as the "Sort by" column.
4. Select the "Values" option in the "Sort On" dropdown.
5. Choose "Largest to Smallest" in the "Order" dropdown.
6. Click "OK" to apply the sorting. The rows will now be sorted based on the rankings in Column D.

Make sure to adjust the column references and range as per your actual data.