Filter nonblanks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kherse sefid - 24 Jul 2007 12:22 GMT

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?

Signature

Thanks in advance
Kherse Sefid

Reply to this Message

Roger Govier - 24 Jul 2007 12:41 GMT

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.

Signature

Regards
Roger Govier

> Hi
>
[quoted text clipped - 12 lines]
> it contains blank cells, but still when I go to DATA/Filter/Autofilter I
> don't get the nonblanks option. How can it be?

Reply to this Message