Autofilter question

**mroctogon** · 11-22-2008, 04:52 PM

Ok, I need to do what should be a fairly simple autofilter operation, but I'm having a bunch of truoble getting it to work. What I really want is to filter column 1 such that ( (x>=2000 And x<3000) Or x="*U*" ). I've read that excel can only take two criteria at a time to the autofilter command, so I've been trying to use an extra column to make it work, but I am still having some problems with the sorting. Heres what I am working on:

Please Login or Register  to view this content.

This does not run properly at all ("AutoFilter method of Range class failed" error)

I am also pretty sure that sequence of autofilter operations will still not accomplish the logic I need. Any suggestions / help would be greatly appreciated.

**davesexcel** · 11-22-2008, 05:07 PM

Lets see the workbook, there should be no reason this can't be done in one autofilter step
Look at the example provided at this thread, look at the code that performs the auto filter.
http://www.excelforum.com/excel-work...hone-bill.html

**mroctogon** · 11-22-2008, 05:18 PM

well the problem with doing it in one step is that I have three conditions to check. The example you gave was great for finding values between x and y, but I need all values between x and y AND all values that contain a certain substring. As far as I know excel only allows two conditions to be checked in a single step.

**davesexcel** · 11-23-2008, 04:43 AM

Originally Posted by mroctogon

well the problem with doing it in one step is that I have three conditions to check. The example you gave was great for finding values between x and y, but I need all values between x and y AND all values that contain a certain substring. As far as I know excel only allows two conditions to be checked in a single step.

Okay, then don't supply an example workbook.