Course / Sort and filter

Filter by numbers, then sort what shows

Show the invoices over an amount, sort them from the ▾ on a heading, and turn the filter off again. Intermediate · 4 min · Number filter, Sort from the heading, Filter off

Ticking values suits a column with a few different entries. For amounts, where nearly every value is different, you want a range instead: everything from 1,000 up.

The ▾ on a column of numbers has two boxes for that, Numbers from and to. Fill in one for a lower or an upper limit, or both for a range.

The same ▾ can also sort by its column, so you rarely need to leave the table: filter down to what matters, then put it in order.

In Excel, the range is under Number Filters in the ▾: Greater Than Or Equal To, Between and the rest.

Steps

  1. Click a cell in the table, such as A2, and turn on Filter.

  2. Show only the large invoices. Open the ▾ on Amount, type 1000 in Numbers from, and click OK.

  3. Put them in order without leaving the table. Open the ▾ on Amount again and click Largest first.

  4. Done with the filter? Click Filter in the toolbar again to turn it off.

Remember

Previous: Filter a table · Next: Turn a range into a table