Auto-filter won't filter
 

I highlighted cell K35 to filter the PO #'s in column K where PO's are listed
randomly down the column starting in row 35 and there are spaces between PO
#'s as you go down the column. I filtered "non-blanks" to bring all of the
PO's together but no filtering occurred.

thoughts?

Perhaps the blanks aren't blank. They could be zero or have a formula which
equates to zero. Go to Tools-Options-View and under Window options select
"Zero values". This will show zero values in the sheet.

Ian

"Jane" wrote in message
...
I highlighted cell K35 to filter the PO #'s in column K where PO's are
listed
randomly down the column starting in row 35 and there are spaces between
PO
#'s as you go down the column. I filtered "non-blanks" to bring all of
the
PO's together but no filtering occurred.

thoughts?

the cells in between are indded blanks without zero values

"IC" wrote:

Perhaps the blanks aren't blank. They could be zero or have a formula which
equates to zero. Go to Tools-Options-View and under Window options select
"Zero values". This will show zero values in the sheet.

Ian

"Jane" wrote in message
...
I highlighted cell K35 to filter the PO #'s in column K where PO's are
listed
randomly down the column starting in row 35 and there are spaces between
PO
#'s as you go down the column. I filtered "non-blanks" to bring all of
the
PO's together but no filtering occurred.

thoughts?

Sorry Jane. I can't think of anything else. Hopefully someone else can.

Ian

"Jane" wrote in message
...
the cells in between are indded blanks without zero values

"IC" wrote:

Perhaps the blanks aren't blank. They could be zero or have a formula
which
equates to zero. Go to Tools-Options-View and under Window options
select
"Zero values". This will show zero values in the sheet.

Ian

"Jane" wrote in message
...
I highlighted cell K35 to filter the PO #'s in column K where PO's are
listed
randomly down the column starting in row 35 and there are spaces
between
PO
#'s as you go down the column. I filtered "non-blanks" to bring all of
the
PO's together but no filtering occurred.

thoughts?

Hi Jane

Rather than just highlighting K35, highlight the whole range containing your
data before applying Autofilter.

--
Regards
Roger Govier
"Jane" wrote in message
...
the cells in between are indded blanks without zero values

"IC" wrote:

Perhaps the blanks aren't blank. They could be zero or have a formula
which
equates to zero. Go to Tools-Options-View and under Window options
select
"Zero values". This will show zero values in the sheet.

Ian

"Jane" wrote in message
...
I highlighted cell K35 to filter the PO #'s in column K where PO's are
listed
randomly down the column starting in row 35 and there are spaces
between
PO
#'s as you go down the column. I filtered "non-blanks" to bring all of
the
PO's together but no filtering occurred.

thoughts?

that did it - thanks!

"Roger Govier" wrote:

Hi Jane

Rather than just highlighting K35, highlight the whole range containing your
data before applying Autofilter.

--
Regards
Roger Govier
"Jane" wrote in message
...
the cells in between are indded blanks without zero values

"IC" wrote:

Perhaps the blanks aren't blank. They could be zero or have a formula
which
equates to zero. Go to Tools-Options-View and under Window options
select
"Zero values". This will show zero values in the sheet.

Ian

"Jane" wrote in message
...
I highlighted cell K35 to filter the PO #'s in column K where PO's are
listed
randomly down the column starting in row 35 and there are spaces
between
PO
#'s as you go down the column. I filtered "non-blanks" to bring all of
the
PO's together but no filtering occurred.

thoughts?

I thought of that, but your original message said you had filtered
"non-blanks" which normally doesn't appear unless there are blanks and
non-blanks in the filtered selection.

Anyway, glad you found the solution and sorry I wasn't much help.

Ian

"Jane" wrote in message
...
that did it - thanks!

"Roger Govier" wrote:

Hi Jane

Rather than just highlighting K35, highlight the whole range containing
your
data before applying Autofilter.

--
Regards
Roger Govier
"Jane" wrote in message
...
the cells in between are indded blanks without zero values

"IC" wrote:

Perhaps the blanks aren't blank. They could be zero or have a formula
which
equates to zero. Go to Tools-Options-View and under Window options
select
"Zero values". This will show zero values in the sheet.

Ian

"Jane" wrote in message
...
I highlighted cell K35 to filter the PO #'s in column K where PO's
are
listed
randomly down the column starting in row 35 and there are spaces
between
PO
#'s as you go down the column. I filtered "non-blanks" to bring all
of
the
PO's together but no filtering occurred.

thoughts?

Jane

Perhaps the "blanks" are not really blank?

In an empty column enter =ISBLANK(K35) then drag/copy down.

Real blanks will return TRUE.


Gord Dibben Excel MVP

On Wed, 9 Feb 2005 09:09:02 -0800, "Jane"
wrote:

I highlighted cell K35 to filter the PO #'s in column K where PO's are listed
randomly down the column starting in row 35 and there are spaces between PO
#'s as you go down the column. I filtered "non-blanks" to bring all of the
PO's together but no filtering occurred.

thoughts?