Page 142 - Ms Excel Note and Workbook
P. 142

MICROSOFT EXCEL NOTE AND WORKBOOK


               4.  The Custom AutoFilter dialog box will appear. Enter the desired date(s) to the right of
                   each filter, then click OK. In our example, we want to filter for dates after or equal
                   to July 15, 2015, and before or equal to August 15, 2015, which will display a range
                   between these dates.







                                                                                 TIP
                                                                         Use custom auto filter
                                                                         dialog box for the selected
                                                                         date filter







               5.  The worksheet will be filtered by the selected date filter. In our example, we can now
                   see which items have been checked out between July 15 and August 15.





















































                                                                                              133 | P a g e
   137   138   139   140   141   142   143   144   145   146   147