Sort data largest to smallest in a column

How to sort data from largest to smallest number in a column using Excel and VBA methods

METHOD 1. Sort data largest to smallest in a column

EXCEL

Select data > Home tab > Sort & Filter > Custom Sort > Select the Column by which to sort > Select which to Sort on > Select Largest to Smallest Order > OK

1. Select the range that captures the data you want to sort.
Note: in this example we are selecting the data with the headers selected. 		Select range to be sorted numerically with headers

2. Select the Home tab. Select Home tab - Excel 2016

3. Click on Sort & Filter in the Editing group.
4. Click on Custom Sort. 		Click on Sort & Filter and click on Custom Sort

5. Select the Column by which you want to sort by.
Note: in this example we are sorting by a column that captures the product quantity and is titled Quantity.
6. Select the Sort on type.
Note: in this example we are sorting by cell values.
7. Select Largest to Smallest from the Order drop down menu.
8. Click OK.
Note: by default the My data has headers checkbox should be checked, however, if it isn't you will need to check the checkbox. 		Select Sort by column, select Cell Values and select Largest to Smallest Order

9. This image represents the result of sorting the selected data from largest to smallest. Sorted data largest to smallest

METHOD 2. Sort data largest to smallest in a column

EXCEL

Select data > Home tab > Sort & Filter > Sort Largest to Smallest

1. Select the range that captures the data you want to sort.
Note: in this example we are selecting the data with the headers selected. 		Select range to be sorted numerically with headers

2. Select the Home tab. Select Home tab - Excel 2016

3. Click on Sort & Filter in the Editing group.
4. Click on Sort Largest to Smallest. 		Click on Sort & Filter and click on Sort Largest to Smallest

5. This image represents the result of sorting the selected data from largest to smallest. Sorted data largest to smallest

METHOD 1. Sort data largest to smallest in a column using VBA

VBA

Sub Sort_Largest_to_Smallest()
'declare a variables
Dim ws As Worksheet
Dim Rng As Range
Set ws = Worksheets("Sheet1")
Set Rng = ws.Range("B3:C9")
'sort data from largest to smallest number in column B
Rng.Sort Key1:=Range("B:B"), Order1:=xlDescending

End Sub

PREREQUISITES
Worksheet Name: Have a worksheet named Sheet1.
Data Range: In this example the data is captured in range ("B3:C9"). This range does not include headings.
Column Order: In this example the data is being sorted from largest to smallest by column B, which is represented by range reference ("B:B").
ADJUSTABLE PARAMETERS
Worksheet Name: Select the worksheet that captures the data that you want sort by changing the Sheet1 worksheet name.
Data Range: Select the data range that you want to sort by changing the range reference("B3:C9").
Column Order: Select the column which you want to sort from largest to smallest by changing the range reference ("B:B") to any column that is within the specified range.
ADDITIONAL NOTES
Note 1: This VBA code assumes that the selected data range does not include headings.

Explanation about how to sort data from largest to smallest in a column

EXPLANATION

EXPLANATION
This tutorial explains and provides step by step instructions on how to sort data from a largest to smallest number in a column using Excel and VBA methods.

Excel Methods: This tutorial provides two examples on how to sort data from largest to smallest, in a column. The first method can be achieved in 8 steps and gives you more functionality through the Sort window. The second method can be achieved in 4 steps, however, it will only sort largest to smallest based on the first selected column.

VBA Method: This tutorial provides one VBA example on how to sort data from largest to smallest, in a column.