Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2008

Tip: Looking for answers? Try searching our database.

multi criteria filter

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Deus DNE - 02 Apr 2008 15:49 GMT
Hi,

If i want to filter a single column to only show A G, J, and P ( i choose
these letters as they cant be lumped together as a range) how would i do
that in a maro or VB

Any tips appreciated

Cheers

Deus
--
DNE
Dave Peterson - 02 Apr 2008 17:23 GMT
You could do it using Data|Advanced filter using a criteria range.

Record a macro when you do it once and you'll have the code.

Debra Dalgleish has some tips for working with Advanced Filter here:
http://contextures.com/xladvfilter01.html

Another option would be to use a helper column that contains formulas that
return true/false and then filter that column to show the trues.

=or(a2={"a","g","j","p"})

You could build that column of formulas manually and hide it, but still use it
in your code.  Again, just record a macro when you do the filter and you'll have
the code.

> Hi,
>
[quoted text clipped - 9 lines]
> --
> DNE

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.