 |
Ron de Bruin
|
 |
|
|
Ron de Bruin
|
|
Briefly! EasyFilter is a multi-optioned tool that allows far easier filtering of data. It allows easier manipulation of the results of the filtering. Once EasyFilter has been installed, all of the options are accessed by simply right clicking any cell within a criteria field in your data range. There is also a new menu item below the *EasyFilter* menu item that say *Clear Filters* to clear the filter. If you open *EasyFilter* it always clear the filter first so no need to always use *Clear Filter*. Important : Use Headers above your Data. Note: The add-in is not working in a Table, I got another add-in named Table Tools for Tables.
I created EasyFilter for Excel 2000-2003 a long time ago and on Aug 2006 I
have upload the last version to my website. It was a great project with help
and suggestions from my Excel friends Norman Harker, Dave Peterson, Bob
Philips and the late Frank Kabel who was
tragically killed in an accident in his home country of Germany on 5th
January 2005.
The new version for the new Excel versions
After 15 years it was time to update the add-in so it is also works in the
last versions of Excel for Windows, there is a Mac version also now.
When I was updating the add-in I not understand why I waited for so long
because it is still a cool tool.
Filter Options are on separate tabbed User Interface and options
available are:
Equal-Not Equal [Filters for up to
five alternative = or <> criteria]
Blanks [Filters for
Blanks or non Blanks or Formulas that evaluate to "" or not]
Greater-Less [Filters for >= OR > AND / OR <= OR <]
Begins-Contains-Ends [Ideal for filtering text fields]
Unique-Duplicate [At last an easy way to hunt out uniques and
duplicates]
Special [Text searching with wild cards with
up to 5 Or / And criteria]
Dates [Not enabled unless
you are filtering a field containing dates]
Color
[Fill/Font colors (Normal and Conditional Formatting colors) and Bold cells]
With exception of Unique-Duplicates, option tab, you have 7 "Where-Hows"
available:
1) Filter in place
2)
Copy to new worksheet
3) Copy to new workbook
4) Delete rows
5) Hide rows
6) Copy next to your data
7) Copy below
your data
And for the “Unique-Duplicate” tabbed option only:
1) Filter in place
2) Copy to another
location
3) Copy to new worksheet
4)
Copy to new workbook
5) Unique or Duplicate
Download version 3.2 for Excel for Windows Date published 22-Oct-2021
Version 3.2 fixed a bug on non English systems and I changed the code for Date filtering.
Extract it to a unprotected local directory and then Click on File, click on Options, click the Add-ins tab. In the Manage drop-down, choose Excel Add-ins, and click Go. Use “Browse” to go to the add-in and then click on OK. Verify EasyFilter is checked in the add-in list and then click OK.
Note: If you not see the menu option to open EasyFilter in the Cell menu when you right click a cell in your data it is possible that Excel block the add-in. Follow the steps below one time to fix this.
1: Close ExcelNote: Please let me know if you have problems with the add-in or have suggestions
Note: If you are a Mac user see this page : EasyFilter | Mac Excel Automation
Many thanks to Norman Harker, Dave Peterson, Bill Manville, Bob Phillips and the late Frank Kabel for their help and suggestions.