I have a spreadsheet that have set on autofilter.
I know that if there are no blanks in a column, "Blanks" and "Nonblanks"
will not appear in the drop-down as an option.
However, in this spreadsheet, I have a date column that DOES have blanks,
and the drop-down does not have an option to filter by blanks.
It used to work. I don't know what changed.
I even tried removing the auto filter and resetting it, and it still doesn't
work.
Any ideas?

One more thing.
I just undid the auto filter. Then I highlighted the date column and
filtered just that column. This time the Blanks and Nonblanks options show
up.
Then if I auto-filter all columns, they stop showing up again.
I want to be able to filter in all the columns, not just the date column.

"skelly1969" wrote:

I have a spreadsheet that have set on autofilter.
I know that if there are no blanks in a column, "Blanks" and "Nonblanks"
will not appear in the drop-down as an option.
However, in this spreadsheet, I have a date column that DOES have blanks,
and the drop-down does not have an option to filter by blanks.
It used to work. I don't know what changed.
I even tried removing the auto filter and resetting it, and it still doesn't
work.
Any ideas?

See your other post.

skelly1969 wrote:

One more thing.
I just undid the auto filter. Then I highlighted the date column and
filtered just that column. This time the Blanks and Nonblanks options show
up.
Then if I auto-filter all columns, they stop showing up again.
I want to be able to filter in all the columns, not just the date column.

"skelly1969" wrote:

I have a spreadsheet that have set on autofilter.
I know that if there are no blanks in a column, "Blanks" and "Nonblanks"
will not appear in the drop-down as an option.
However, in this spreadsheet, I have a date column that DOES have blanks,
and the drop-down does not have an option to filter by blanks.
It used to work. I don't know what changed.
I even tried removing the auto filter and resetting it, and it still doesn't
work.
Any ideas?

--

Dave Peterson

Sorry, what do you mean? I don't see any responses to my other post, aside
from my own where I provided more info. I've never used this forum before --
are there responses that I'm not seeing?

"Dave Peterson" wrote:

See your other post.

skelly1969 wrote:

One more thing.
I just undid the auto filter. Then I highlighted the date column and
filtered just that column. This time the Blanks and Nonblanks options show
up.
Then if I auto-filter all columns, they stop showing up again.
I want to be able to filter in all the columns, not just the date column.

"skelly1969" wrote:

I have a spreadsheet that have set on autofilter.
I know that if there are no blanks in a column, "Blanks" and "Nonblanks"
will not appear in the drop-down as an option.
However, in this spreadsheet, I have a date column that DOES have blanks,
and the drop-down does not have an option to filter by blanks.
It used to work. I don't know what changed.
I even tried removing the auto filter and resetting it, and it still doesn't
work.
Any ideas?

--

Dave Peterson

Are you also posting as MitchellWMA?

If you're not, then sorry. (Your question and MitchellWMA's question was so
close (and unusual), that I thought it was from the same person.)

Remove the autofilter.
Select the range (don't let excel guess)
reapply the autofilter.

Filter by any field (use custom not equal to xxxxxx--some unused string).

You'll notice that the row numbers change colors in the autofiltered range.

Is the range what you expected?

====
If you select a cell in a range and let excel guess at the range that should be
filtered, it often (always???) stops the range when it encounters an empty row
or empty column.



skelly1969 wrote:

Sorry, what do you mean? I don't see any responses to my other post, aside
from my own where I provided more info. I've never used this forum before --
are there responses that I'm not seeing?

"Dave Peterson" wrote:

See your other post.

skelly1969 wrote:

One more thing.
I just undid the auto filter. Then I highlighted the date column and
filtered just that column. This time the Blanks and Nonblanks options show
up.
Then if I auto-filter all columns, they stop showing up again.
I want to be able to filter in all the columns, not just the date column.

"skelly1969" wrote:

I have a spreadsheet that have set on autofilter.
I know that if there are no blanks in a column, "Blanks" and "Nonblanks"
will not appear in the drop-down as an option.
However, in this spreadsheet, I have a date column that DOES have blanks,
and the drop-down does not have an option to filter by blanks.
It used to work. I don't know what changed.
I even tried removing the auto filter and resetting it, and it still doesn't
work.
Any ideas?

--

Dave Peterson


--

Dave Peterson

Nope, I'm not posting as MitchellWMA -- I didn't see that post.

This worked -- thanks for your help!

"Dave Peterson" wrote:

Are you also posting as MitchellWMA?

If you're not, then sorry. (Your question and MitchellWMA's question was so
close (and unusual), that I thought it was from the same person.)

Remove the autofilter.
Select the range (don't let excel guess)
reapply the autofilter.

Filter by any field (use custom not equal to xxxxxx--some unused string).

You'll notice that the row numbers change colors in the autofiltered range.

Is the range what you expected?

====
If you select a cell in a range and let excel guess at the range that should be
filtered, it often (always???) stops the range when it encounters an empty row
or empty column.



skelly1969 wrote:

Sorry, what do you mean? I don't see any responses to my other post, aside
from my own where I provided more info. I've never used this forum before --
are there responses that I'm not seeing?

"Dave Peterson" wrote:

See your other post.

skelly1969 wrote:

One more thing.
I just undid the auto filter. Then I highlighted the date column and
filtered just that column. This time the Blanks and Nonblanks options show
up.
Then if I auto-filter all columns, they stop showing up again.
I want to be able to filter in all the columns, not just the date column.

"skelly1969" wrote:

I have a spreadsheet that have set on autofilter.
I know that if there are no blanks in a column, "Blanks" and "Nonblanks"
will not appear in the drop-down as an option.
However, in this spreadsheet, I have a date column that DOES have blanks,
and the drop-down does not have an option to filter by blanks.
It used to work. I don't know what changed.
I even tried removing the auto filter and resetting it, and it still doesn't
work.
Any ideas?

--

Dave Peterson


--

Dave Peterson

Sorry about my confusion!

skelly1969 wrote:

Nope, I'm not posting as MitchellWMA -- I didn't see that post.

This worked -- thanks for your help!

"Dave Peterson" wrote:

Are you also posting as MitchellWMA?

If you're not, then sorry. (Your question and MitchellWMA's question was so
close (and unusual), that I thought it was from the same person.)

Remove the autofilter.
Select the range (don't let excel guess)
reapply the autofilter.

Filter by any field (use custom not equal to xxxxxx--some unused string).

You'll notice that the row numbers change colors in the autofiltered range.

Is the range what you expected?

====
If you select a cell in a range and let excel guess at the range that should be
filtered, it often (always???) stops the range when it encounters an empty row
or empty column.



skelly1969 wrote:

Sorry, what do you mean? I don't see any responses to my other post, aside
from my own where I provided more info. I've never used this forum before --
are there responses that I'm not seeing?

"Dave Peterson" wrote:

See your other post.

skelly1969 wrote:

One more thing.
I just undid the auto filter. Then I highlighted the date column and
filtered just that column. This time the Blanks and Nonblanks options show
up.
Then if I auto-filter all columns, they stop showing up again.
I want to be able to filter in all the columns, not just the date column.

"skelly1969" wrote:

I have a spreadsheet that have set on autofilter.
I know that if there are no blanks in a column, "Blanks" and "Nonblanks"
will not appear in the drop-down as an option.
However, in this spreadsheet, I have a date column that DOES have blanks,
and the drop-down does not have an option to filter by blanks.
It used to work. I don't know what changed.
I even tried removing the auto filter and resetting it, and it still doesn't
work.
Any ideas?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson