Advanced Filter display blanks and ???

Originally Posted by Cocoano

I need to create an advanced filter that shows a typed in option and also any blank rows.
Have been looking since yesterday afternoon and found snippets of things that don't work... ="=", ="=""""", or(isblank(range)), don't have a name in the criteria head line on that column, etc.

Essentially I want the users to enter their selection across the first criteria row and the second is hidden from their view:

Model Color Size
ABC1 Blue M
=(cell above) BLANK


The data is as follows:

Model Color Size
ABC1 Blue M
ABC1 Blue L
ABC1 Blue
ABC1 Pink M


When the user puts in "ABC1", "Blue" and "M" I want the result to be 2 rows - the first and third of the data which would mean that it is showing the size row that is blank as well as the line which has the "M".

Hope I've explained myself well enough.

Thanks for any help, I'd love to get my eyes uncrossed and not be eyeing that bottle of wine that someone gifted me this morning!

Hi,

Yes, that works

with standard AutoFilter, select Blue from the dropdown.
For the M, select Custom, 'Equals' and select M from the choices
OR
'Equals'

and press OK

hth
---

Originally Posted by Cocoano

Absolutely it works as a regular auto-filter, but what I want for the users is a line they fill in and then the advanced filter does the rest. They are not selecting drop down options, they are typing information in a field and the advanced filter is to do the rest.

In the sheet, rightmouse the tab and select View Code
paste this code there.

Please Login or Register  to view this content.

Currently set to trigger when column C entry is made, switch the two lines for columns B & C (remove the ' from one and apply it to the other)

Let me know how you go.
---