Is there way to make custom categories in Autofilter...for instance, in one of my columns I have home sale prices, and rather then selecting individual prices in the drop down menu I would like to be able to select ranges (ex. less than $399,999; $400,000-$699,000 ect.) I would like to be able to do this without having to use Custom Autofiltering for each search criteria. Thanks in advance.
Select Custom option from the drop down auto filter list - (at the bottom of the list)
You the have options of entering/selecting 1 or 2 values using operators of =, >, =>, <=, < in conjunction with the values
When using 2 values you also use need to select And, Or operators
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
I would like to be able to have certain options available in the drop down menu and NOT have to use the Custom Filtering option each time. Is there any way to do this?
Maybe take a look at advance filters
http://www.contextures.com/xladvfilter01.html
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks