Sorting, Filtering & Lists
Excel Yes/No Drop Down: add one in 20 seconds
Make a Yes/No drop down in Excel with Data Validation, colour Yes green and No red, and count the answers.
Category: Sorting, Filtering & Lists
Sorting, Filtering & Lists
Excel Unique Values: list each item once
Get a list of unique values in Excel three ways: the UNIQUE function, Remove Duplicates on a copy, and Advanced Filter for older Excel — plus counting them.
Sorting, Filtering & Lists
Sort in Excel: A to Z, by number, by date, by two columns
Sort in Excel without scrambling your data: one column, two columns (by city then name), by date, and put it back the way it was.
Sorting, Filtering & Lists
Excel Filter: show only the rows you want
Turn on the Excel filter with one shortcut, filter by value, text, number or date, see how many rows match, and clear it.
Sorting, Filtering & Lists
Data Validation in Excel: only allow the right values
Data validation in Excel: limit a cell to whole numbers, a date range, a list, or text length, with your own error message.
Sorting, Filtering & Lists
Excel Drop Down List: make one in 30 seconds
Make an Excel drop down list with Data Validation in 30 seconds, from typed options or from a range, and edit it later.
6 tutorials · Page 1 of 1
