Advanced Filter "la90292" <la90292[ at ]myrealbox.com> 19.09.2006 23:40:41 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

Re: Advanced Filter Dave Peterson <petersod[ at ]verizonXSPAM.net> 20.09.2006 00:16:50 Check out Debra Dalgleish's site: http://contextures.com/xladvfilter01.html http://contextures.com/xladvfilter01.html#CriteriaRange la90292 wrote: [Quoted Text] > > 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