nonblank filters in excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i find nonblank filters in excel when working with spreadsheets
 
robert mills said:
how do i find nonblank filters in excel when working with spreadsheets
Click to expand...

Just sparing a thought here, as you haven't received any response yet (not
sure why, though <g>). ok, I don't have/know the latest xl2007, but would it
be any different from say, xl2003, where the option to choose: (NonBlanks) is
available in the autofilter dropdown (via Data > Filter > Autofilter)?

---
 
Hi Robert

When you select the whole data column and there are blanks
you see "Blanks" in the filter list when you click on the arrow in the header
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting nonblank rows 8
Copy only nonblank cells 8
How do I find the minimum NONBLANK value in a sequence of cells? 3
Why can't I add rows or columns on my worksheet? 1
Filter nonblank AND unique 1
How do I count nonblanks in column A when I filter by column B 5
count how many rows contain nonblank in column A and blank in colu 5
Filter for blanks - nonblanks problem 1

Back
Top