Wednesday, June 29, 2011

Types Of Filters In Microsoft Excel

In Microsoft Excel depending on the search criteria we have two types of filters. Filters are useful in selecting the search criteria and helps in finding the required data easily. 

Types of Filters: 

1) Common Filter
  • A common filter is a filter that is based on a comparison operator. Click one of the comparison operator commands (Equals, Before, After, or Between) or click Custom Filter. 
  • When we create a criteria for date, in the Custom AutoFilter dialog box, in the box on the right, enter a date or time, select a date or time from the list, or click the Calendar button to find and enter a date.
  • To filter by a lower and upper date or time, select Between.


  • In the Custom AutoFilter dialog box, in the box or boxes on the right, enter a date or time, select dates or times from the list, or click the Calendar button to find and enter a date.

2) Dynamic Filter: 

A dynamic filter is a filter in which the criteria can change when you reapply the filter.
  • Click one of the pre-defined date commands.
  • To filter all dates by the current date, select Today, or to filter by the following month, select Next Month.
  • Click OK.

3 comments:

Heya i am for the first time here. I found this board and I find
It truly useful & it helped me out a lot. I hope to give something
back and aid others like you helped me.

Feel free to visit my website :: best downloads

Post a Comment

Search This Blog

Followers

Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More