Filtering by More Than Two Criteria in Excel 2007

To filter a List using more than one criteria, use the Advanced Filter: 1. Insert three new rows above the List. 2. Copy the heading row List, and...

Coloring Visible Rows in Filtered List in Excel 2007

To color filtered List according to a criteria: 1. Filter the List according to any criteria. 2. Select a cell in filtered area, press Ctrl+Shift+...

Summing the Visible Filtered List Values in Excel 2007

To total the values in the visible filtered rows, use the SUBTOTAL function: 1. Filter the List by selecting any criteria. 2. Select a cell in the...

Filtering by Data Type in Excel 2007

When filtering the List, Filter recognizes the type of data in each field: such as text, date or a numeric number. The sub-menu filters is changed...

Sort Ascending/Descending While Using Filter in Excel 2007

To sort a List: This option enables to sort from the Filter dropdown list identical to the Sort A to Z/Sort Z to A or Sort by Color). ...

The Filter Ribbon in excel 2007

To add filters to a List: Select Home -> Sort & Filter (in Editing Group -> Filter. Or Select Data -> Filter (in Sort & Filter G...

Filtering a List into Unique Records Using the COUNTIF Formula in Microsoft Excel

If you have a range of values which contain duplicates, we have an interesting way of filtering for these duplicate values. This is one of the ways of...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube