EasyFilter Add-in Home
(Filter, Copy, Delete and Hide rows in Excel 2000 and Higher)
What Does EasyFilter Do?
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 under the
Data > Filter menu or by simply right clicking any cell within a criteria field in your data table.
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
Dedication
This Version of EasyFilter is dedicated to the memory of Excel MVP Frank
Kabel who was tragically killed in an accident in his home country of
Germany on 5th January 2005.
Frank was a tireless tester of the Beta editions of this version of EasyFilter
and made many suggestions and comments that make this version what
you see today. Some suggestions for development and methods of
execution still remain to be implemented in later versions.
The Excel community has lost one of the most prolific communicators,
educators, and application developers.
We offer condolences at this difficult time to Frank’s family, long term
girlfriend and his many other friends.
We have lost a good friend.
Ron de Bruin
Norman Harker
Download
If you use Excel 2007 you can't use EasyFilter, I create this add-in for Excel 2007.
http://www.rondebruin.nl/table.htm
New in version 2.01
1) Options to "Copy next to your data" and "Copy below your data"
2) The “Dates” tabbed option is the major innovation of Version 2.0.
You have the following filter options on this tab.
Month-Year, Days, Weeknumber, Weekday, Nth Weekday, Quarter.
Download Version 2.01 (Add-in date: 20-March-2005)
New in version 2.22 NEW
With version 2.2 you can also filter on fill/font colors (Normal and Conditional Formatting colors) and on bold cells.
On the Blanks tab you can also filter now on
Formulas that evaluate to "" and Formulas that don't evaluate to ""
Download Version 2.22 (Add-in date: 23-Aug-2006)
If you need help please read this Superb manual (for version 2.01) first from Excel MVP Norman Harker.
All examples shown in this User Guide are examples that use the EasyFilter Sample Database.xls file.
Download the User Guide
(made by Norman Harker) Word document
Download the User
Guide (made by Norman Harker) PDF document
Download the EasyFilter
Sample DataBase (made by Norman Harker)
Note : This is the third public version, please mail me if you have problems
with this version or if you have suggestions.
Acknowledgements
Many Thanks to Excel MVPs Dave Peterson, Bill Manville, Bob Phillips, the late Frank Kabel and Norman Harker
for their help and suggestions.
Legal Stuff
This utility is distributed freely and with maximum exclusion of liability permitted by law.
Further distribution is permitted subject to:
1. Such distribution not being directly or indirectly for gain or reward, and 2. Distribution being together with these notes, and 3. Appropriate and prominent attribution to Ron de Bruin.
Copyright on VBA coding and techniques used to create this program is specifically retained.
Use of this program is subject to the restriction that there should be no access to or copying
of the VBA Project that forms part of the workbook without consent of Ron de Bruin and use
of a password provided only by him for that purpose.