Google Sheets:

Sorting and Filtering Data

1. Open our example file. Make sure you're signed in to Google, then click File > Make a copy.
2. Select the Equipment Log tab if it is not already open.
3. Freeze row 1.
4. Sort the spreadsheet by the Checked Out date from most recent to the oldest.
5. Hint: Sort by column D from Z to A.
6. Sort the range A2:F9 by column B from A to Z.
7. Hint: Make sure the box next to data has header row is left unchecked.
8. Filter the spreadsheet so it only shows equipment that has never been checked in.
9. Hint: Filter column E to show cells that are empty.
10. When you're finished, your spreadsheet should look like this:

Click here for the complete lesson