Filtering with multiple criteria


F

fgwiii

Hello,

I have a spreadsheet that contains multiple columns one of which is called
"SITE NO". I am looking to create a macro that would include multiiple site
numbers and have the records filtered just for the sites listed in the
macro. The site numbers are 5 digits long such as "17005, 18010, 34111,
12022, 15563" for example.

Thanks

Fred
 
Ad

Advertisements

L

Luke M

The easiest way is probably to set up a helper column out of the way (say,
column AZ) and have a formula like
=OR(A2=17005,A2=18010,A2=34111,A2=12022,A2=15563)

and then record a quick macro of you filtering column AZ for "TRUE". This
way would also be easier to change which values you want to filter for.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top