What this calculator does
Putting a list of numbers into ascending order means arranging them from smallest to largest. It sounds trivial with five numbers written on paper, but it stops being trivial the moment the list has thirty entries, mixes negative numbers with positive ones, or includes decimals that are easy to misjudge at a glance.
This calculator takes any list, pasted or typed in, and returns it sorted both ways: ascending and descending, along with the count, sum, smallest and largest value, so a single paste answers most of the questions someone reaches for a sorted list to answer in the first place.
The formula
Every number in the list is compared numerically, not alphabetically, so "9" correctly sorts before "10" rather than after it as text sorting would place it. The list is then read out lowest to highest for ascending order, and the same sorted list reversed gives descending order.
| Term | Meaning |
|---|---|
| Ascending order | The list arranged from the smallest value to the largest. |
| Descending order | The list arranged from the largest value to the smallest, the reverse of ascending order. |
The inputs explained
| Field | What to enter |
|---|---|
| Numbers (comma or space separated) | Paste or type the numbers, separated by commas, spaces or line breaks. Negative numbers and decimals are both handled correctly. |
When to use it
Sorting a data set before analysis
Finding the median, quartiles or a specific rank by hand needs the data sorted first; this calculator does that step instantly for a list of any length.
Checking homework or a spreadsheet formula
Pasting the same numbers here and comparing against a spreadsheet's SORT output is a quick way to confirm a formula is working as expected.
Arranging scores, prices or measurements for reporting
A list of results is often clearer to a reader in ascending or descending order than in whatever order it was originally recorded.
Worked examples
Every figure in the tables below is produced by this page’s own calculator at build time, so the numbers and the tool always agree. Select any row to load that scenario.
How does ascending order handle different kinds of number lists?
The same sorting logic applied to a few different kinds of input list.
| Input list | Ascending order | Descending order |
|---|---|---|
| 42, 7, 19, 3, 27, 11 | 3.000, 7.000, 11.000, 19.000, 27.000, 42.000 | 42.000, 27.000, 19.000, 11.000, 7.000, 3.000 |
| -4, 2.5, 0, -10, 8 | -10.000, -4.000, 0, 2.500, 8.000 | 8.000, 2.500, 0, -4.000, -10.000 |
| 100, 9, 55, 2, 1000 | 2.000, 9.000, 55.000, 100.000, 1,000.00 | 1,000.00, 100.000, 55.000, 9.000, 2.000 |
Questions
Does this sort text or only numbers?
Only numbers. Anything in the input that is not a valid number, such as stray letters or symbols, is ignored rather than sorted, so a list mixing labels and values needs the labels removed first.
How are duplicate numbers handled?
Duplicates are kept and sorted in place alongside every other value; the calculator does not remove repeated entries, since a duplicate is usually meaningful data, not an error.
Can I sort decimals and negative numbers together?
Yes. The list is compared numerically rather than as text, so decimals sort correctly by their actual value and negative numbers sort correctly below zero and below every positive number.
What is the difference between this and a full statistics calculator?
A statistics calculator, such as the mean, median or standard deviation tools, uses the sorted order internally but reports a single summary figure. This calculator instead returns the full sorted list itself, which is what is needed when the ordering, not a summary statistic, is the actual goal.
To find the middle value of a sorted list rather than the full ordering, use the median calculator. For the arithmetic mean and other summary figures, see the average calculator.