Advanced filter, criteria Blank Cell

**ste_mulv** · 01-07-2010, 05:22 AM

Hi There,

I cannot work out the syntax to run an advanced filter for all Non-Blank Columns!

I have attached an example sheet, and you can see my syntax in cell D4.

I am looking to bring through a list of all line that are both Status= "NOT QUOTED YET" and Project Name= NOT Blank.

Unfortunatley, the Status Row will be set as NOT QUOTED YET when there is no project name enetered, hence the problem.

Any suggestions?

Best regards,

Steve

**contaminated** · 01-07-2010, 05:35 AM

Edit:
Misposted.....

**ste_mulv** · 01-07-2010, 07:06 AM

Hi There,

Not sure what was wrong with my last post, but I have worked out what I needed to get the advanced filter to no included blank cells...

the value was <>

I hope this helps in the future for people trying to make their reports with Excel.

Best regards,

Steve