Advanced Filter

[efernandes67]

Hi,

See file in attach.

I have a table "Table1" and 2 criterias, "Criteria1" and "Criteria2".

If I use an advanced filter using "Table1[#All], "Criteria2" and "Extract2", it works ok and I get the names that match an "Order" number > 0.

If I use an advanced filter using "Table1[#All], "Criteria1" and "Extract1", it does not work.
Witch formula should I use in cell "F4" to get the names that do not have an "Order" number.

Regards,
Elio Fernandes

[TMS]

Assuming you are trying to get the same output in different ways, you need two criteria: not equal to 0 and not equal to blank/null

List Range: $B$7:$D$23
Criteria Range: $E$3:$F$4
Copy to: $F$7


Regards

[efernandes67]

I just found a way.

1) The top cell of the criteria "F4" should be BLANK
2) Cell F5 with the formula "=ISNUMBER($D8)=FALSE"

Regards,
Elio Fernandes

[TMS]

Or, just:

F4 equal to '= ... that is, single quote and an equals sign.

Sorry, I think I misunderstood the requirement.

Regards