Filter nonblanks

  • Thread starter Thread starter kherse sefid
  • Start date Start date
K

kherse sefid

Hi

I have a column that looks like this:

2
43

23
21

3

12

it contains blank cells, but still when I go to DATA/Filter/Autofilter I
don't get the nonblanks option. How can it be?
 
Hi

If you just place the cursor in the header cell and apply Autofilter, it
will think the range stops after 43 and your dropdown will only show 2 and
43.
Mark the complete range of data, then apply Autofilter and you will see each
of the numbers as well as Blanks and Non Blanks as options.
 

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

Copy only nonblank cells 8
select last column and last nonblank cell 4
last nonbank celll 3
Cant add a column 1
How do I count nonblanks in column A when I filter by column B 5
Filter not showing blanks option 6
count how many rows contain nonblank in column A and blank in colu 5
Looking uprange for next nonblank cell 4

Back
Top