Filter BLank

[nrich61]

Hello,

i did try to search, and was surprised i couldnt find it already asked in the forums. I am trying to filter rows that contain blanks cells in a specific column, there is a column header and i am able to use advanced filter for all the other criteria i need...... but nothing i have googled has been able to work......


i have attached a picture of my criteria so far, and again it all works perfectly, I just cant figure out how to filter the frickin blank rows . Thanks.


and using auto-filter is not an option for what i am doing .

[oldchippy]

I just cant figure out how to filter the frickin blank rows

Your example doesn't show any frickin blank rows?

[nrich61]

thats my filter criteria for one of my searches..... i just need to make another to find blank cells in the "date_trans" column.

thanks

[oldchippy]

Select the cells A2:F8, go to Data > Filter > Auto filter, then search column B for frickin blanks

[nrich61]

....... k, im automating this for use by people who are not so good on the computer. all my many different filters are setup, like 6 or 7 different filters are run and copied to other worksheets, so i need to know the proper formula's for filtering blank cells in a column......


added a picture of the actual list i am filter the data from.

thanks.

[nrich61]

actually your suggestion gave me an idea!!

i macro'd the autofilter choosing to have it show blanks, then i just looked at the code and viola!!!


thanks


and for reference its:

="="

[oldchippy]

Glad to hear you got it sorted - thanks for the solution