kevinonexcel
New Member
- Joined
- Jul 15, 2010
- Messages
- 13
Hello,
I am using an advanced filter for a large database. The filter criteria are dependent upon another worksheet. In some cases the criteria in a column is blank. This is done by using an IF function and "". When ever a column is blank, I don't want their to be any criteria is that column. However, whenever I try filtering a case with a blank no solutions appear even though their are valid options. Do I need to add something between my quotations to filter a blank?
Thanks for any help
I am using an advanced filter for a large database. The filter criteria are dependent upon another worksheet. In some cases the criteria in a column is blank. This is done by using an IF function and "". When ever a column is blank, I don't want their to be any criteria is that column. However, whenever I try filtering a case with a blank no solutions appear even though their are valid options. Do I need to add something between my quotations to filter a blank?
Thanks for any help