Page 140 - Ms Excel Note and Workbook
P. 140
MICROSOFT EXCEL NOTE AND WORKBOOK
4. The Custom AutoFilter dialog box will appear. Enter the desired number(s) to the right
of each filter, then click OK. In our example, we want to filter for ID numbers greater
than or equal to 3000 but less than or equal to 6000, which will display ID numbers in
the 3000-6000 range.
TIP
Advanced number filters
allow you to manipulate
numbered data in different
ways.
5. The data will be filtered by the selected number filter. In our example, only items with
an ID number between 3000 and 6000 are visible.
131 | P a g e
