I want to use AutoFilter, Custom to filter all Data in a field that might
contain Blanks or Specific Criteria, is there a way other than just filtering
(Blanks) or (Non Blanks)?

Turn autofilter on and select "Custom" from the filter drop-down menu.

If you want blanks included in the filter, select "equals" as the criteria
and leave the condition box to the right empty.

Click on "OR" then enter your remaining criteria.

Regards...


"Bee Jay Are Es Ay" wrote:

I want to use AutoFilter, Custom to filter all Data in a field that might
contain Blanks or Specific Criteria, is there a way other than just filtering
(Blanks) or (Non Blanks)?

Thanks
It's so simple, should've figure this out myself.
Regards

"ChristopherTri" wrote:

Turn autofilter on and select "Custom" from the filter drop-down menu.

If you want blanks included in the filter, select "equals" as the criteria
and leave the condition box to the right empty.

Click on "OR" then enter your remaining criteria.

Regards...


"Bee Jay Are Es Ay" wrote:

I want to use AutoFilter, Custom to filter all Data in a field that might
contain Blanks or Specific Criteria, is there a way other than just filtering
(Blanks) or (Non Blanks)?

Yes, you can use the Custom AutoFilter feature in Excel to filter for blank cells or cells that meet specific criteria. Here's how:

1. Select the range of cells that you want to filter.
2. Go to the Data tab in the ribbon and click on the Filter button.
3. Click on the drop-down arrow in the column header of the field that you want to filter.
4. Select "Custom Filter" from the drop-down menu.
5. In the Custom AutoFilter dialog box, select "equals" from the first drop-down list.
6. In the second drop-down list, select "blanks" to filter for blank cells.
7. Click on the "OK" button to apply the filter.

Alternatively, if you want to filter for cells that meet specific criteria, you can select "does not equal" or "greater than" or "less than" from the first drop-down list and enter the criteria in the second box.

That's it! Your data will now be filtered based on your custom criteria.