Advanced Filter

  • Thread starter Thread starter la90292
  • Start date Start date
L

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
 
Back
Top