Advanced Filter

[la90292]

I need help with my advanced filter.

I want to filter my customer list, sheet 1 to work sheet 2, with only the
customers located in Palm Springs, Rancho Mirage, Indian Wells, La Quinta &
Cathedral City, CA. In cell W43, I have inputed CITY & below that, W44:48
the cities as referenced above. How would I set up the criteria and
operators to do the advanced filter?

Thanks for you help.

Best regards,
victor

 

[Dave Peterson]

Check out Debra Dalgleish's site:

http://contextures.com/xladvfilter01.html
http://contextures.com/xladvfilter01.html#CriteriaRange