Managing a Filtered List
In Excel, you can work with a filtered list the same way you work with an entire list. In Filter mode, some Excel commands affect only the filtered list. For example, you can sort the sets of data in a filtered list to display them in a particular order without affecting the sets of data that are not included in the filtered list.
Example. The Filter.xls workbook is open. Filter the Payroll list to display only records for the Children’s department, then sort the filtered list. Choose Data, Filter, AutoFilter to display the drop-down arrows for each column. Display the DEPT drop-down list, select Children’s. choose Data, Sort. In the Sort By dialog box, select DIVISION. Verify that Ascending is selected. In the first Then By box, select LAST. Verify that Ascending is selected. In the second Then By box, select FIRST. Verify that Ascending is selected. Click on Ok.
The AutoSum button works with a filtered list just as it does with the entire list. However, if you click on the AutoSum button in Filter mode, Excel does not use the SUM function. Instead, it uses the SUBTOTAL function. The SUBTOTAL function enables the sum to change according to the filtered data that is displayed. He function updates when you change the filter or display the entire list to include all sets of data. E.g. using the AutoSum button on our filtered list. On the vertical scroll bar, click in the area below the scroll box. Select cell K99. Click on the AutoSum button. Press Enter. The value will display. (The SUBTOTAL function was entered. When you use the AutoSum button on a filtered list, Excel uses the SUBTOTAL function instead of the SUM function).
Regards,
Bem T. Celestine
Social Plugin