advanced filter will only work for one criterion

[daveyc18]

for some reason, the advance filter only works for one criterion...when i try to expand the range...it stops working...

e.g im only filtering for

OSP
397

if i add another column

OSP
400


the advanced filter via VBA stops working (just shows blank).....yes, I have modified the named range to capture the additional column...this is driving me nuts

 

[DanteAmor]

You can put all your VBA code, an example of your data and an example of the criteria

 

[daveyc18]

update

if i add just one "OSP" column and then add another filter column

Quantity
>=1000000


the advanced filter works...but the momemnet I add another "OSP" column, it stops working

 

[daveyc18]

You can put all your VBA code, an example of your data and an example of the criteria

Range("A1:AA" & finalrow).AdvancedFilter Action:=xlFilterInPlace, _
CriteriaRange:=Range("test")



again, when "test" consists of...

OSP
397

another column

Quantity
>=1000000


...the advanced filter works fine


OSP
397

another column

OSP
400


the advanced filter doesn't work for multiple "OSP" headers...the source data definitely has it........what is going on here?

 

[DanteAmor]

Sorry but I can not help you if you do not put an example of your data

And what are you waiting for?

 

[DanteAmor]

Do you want me to filter those that are equal to 397 or equal to 400?

It does not go in another column they go down:

[TABLE="class: grid, width: 76"]
<tbody>[TR]
[TD="width: 76, align: center"]OSP[/TD]
[/TR]
[TR]
[TD="align: right"]397[/TD]
[/TR]
[TR]
[TD="align: right"]400[/TD]
[/TR]
</tbody>[/TABLE]

Expand your test range from the title "OSP" to the row with the data 400

 

[mikerickson]

As DanteAmor alluded to

Adding criteria columns adds those criteria with an AND.
Adding criteria rows adds those criteria with an OR.

 

[daveyc18]

yah im a dumbass...thanks for the replies, guys

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.

 

[daveyc18]

arlight i have another problem

this is how my advance filter is set up

column A = acct #

column B = quantity

column C = value

column D = ID


each account # has the same criteria ....quantity >=10, value = 0....the "ID" column (column D) is blank because i need to capture all the IDs

the only exception is account #217...I still want quantity >=10, value = 0., BUT I want to EXCLUDE any IDs that start with "8," "9," "B", "X", and "T."

i tried to entering multiple rows for 217, each row having a different exclusion in column D (e.g., one row is "<>8*", another row is "<>*9), but it doesn't work.