HTML tutorial
CSS3 tutorial
Bootstrap tutorial
JavaScript tutorial
JQuery tutorial
AngularJS tutorial
React tutorial
NodeJS tutorial
PHP tutorial
Python tutorial
Python3 tutorial
Django tutorial
Linux tutorial
Docker tutorial
Ruby tutorial
Java tutorial
C tutorial
C ++ tutorial
Perl tutorial
JSP tutorial
Lua tutorial
Scala tutorial
Go tutorial
ASP.NET tutorial
C # tutorial
The Sort Range command in Google Sheets allows for more complex sorting of data
The Sort Range command in Google Sheets allows for more complex sorting of data.
For example it can work with data which has headers or have multiple sort rules.
Sort range makes it very easy to sort data with headers.
Example
Sort the Pokemon in the range A2:A21
by their Total stats, ascending from smallest to largest (A-Z).
Copy the values to follow along.
Sort range, step by step:
A2:B21
B
Google Sheets lets you sort your data in multiple levels.
Example
Sort the Pokemon in the range A2:A21
by their Total stats, ascending from smallest to largest (A-Z) and then sort the results based on their Name.
Multi-level sort range, step by step:
A2:B21
B
A
Let's compare the results of this example with the previous example:
The image with the blue rectangle is the result of the first example and the image with the green rectangle is the result of the second example.
Look at rows 14:16
.
The order of Pokemon has changed. In the second example they are also sorted alphabetically.
This is because we added an additional sort rule to Sort range.
function copyFormulas(elementId){ /* Get the text field */ var copyText = document.getElementById(elementId); /* Select the text field */ copyText.select(); copyText.setSelectionRange(0, 99999); /* For mobile devices */ /* Copy the text inside the text field */ navigator.clipboard.writeText(copyText.value) .then(() => { alert('Range copied to clipboard.\nIt can now be pasted into the Google Sheets spreadsheet.') }) .catch((error) => { alert(`Copy failed! ${error}`) }) }