AutoFilter defect or my mistake?
 

I have a table of data with positive and negative numbers in column
B. Row 1 is a "title" row; but in fact, all cells are blank. I
select all the columns and enable AutoFilter. The selection buttons
are in Row 1, as expected.

But when I click on the column B button and select Sort Ascending, it
appears that Row 2 is not included in the sort. B2 contains -19,
whereas B3 is -6399, B4 has -181, B5 has -161, and all subequent cells
in column B appear to be sorted appropriately.

Similarly, when I select Sort Descending, B2 remains -19, where B3 has
8900, B4 has 3272, etc. Again, it appears that Row 2 is not included
in the sort.

Why? If I am doing something wrong, I don't see it (sigh).

When I had this problem before, it was because I did not include a
title row. It was noted that AutoFilter assumes that the first
selected row contains titles.

As "proof" that that is not the case this time, note that when I
select Custom "greater than 0", the cell with -19 (B2) is
appropriately hidden, as expected.

The table was downloaded from a web site. ISNUMBER(B2) is true.

AutoFilter defect or my mistake?
 

Hi,

You need column titles, if you don't use them then the first row of data is
assumed to be the titles.
--
Cheers,
Shane Devenshire


" wrote:

I have a table of data with positive and negative numbers in column
B. Row 1 is a "title" row; but in fact, all cells are blank. I
select all the columns and enable AutoFilter. The selection buttons
are in Row 1, as expected.

But when I click on the column B button and select Sort Ascending, it
appears that Row 2 is not included in the sort. B2 contains -19,
whereas B3 is -6399, B4 has -181, B5 has -161, and all subequent cells
in column B appear to be sorted appropriately.

Similarly, when I select Sort Descending, B2 remains -19, where B3 has
8900, B4 has 3272, etc. Again, it appears that Row 2 is not included
in the sort.

Why? If I am doing something wrong, I don't see it (sigh).

When I had this problem before, it was because I did not include a
title row. It was noted that AutoFilter assumes that the first
selected row contains titles.

As "proof" that that is not the case this time, note that when I
select Custom "greater than 0", the cell with -19 (B2) is
appropriately hidden, as expected.

The table was downloaded from a web site. ISNUMBER(B2) is true.

AutoFilter defect or my mistake?
 

On Jun 2, 11:51 am, ShaneDevenshire
wrote:
You need column titles, if you don't use them then the first row of data is
assumed to be the titles.

Thanks. I suspected as much, and I should have tested that hypothesis
first. But I thought my example with Custom selection was "proof"
enough. Sigh, I guess not!

FYI, if the selected AutoFilter range has __two__ blank rows, then the
sort fails altogether with an error (pop-up).