G
Guest
In Win 2003 Excel with a list of columns, one column has numerous blank cells
and the adjacent column is blank (except for the header). With autofilter
on, a value is selected from the drop down box. The first set of rows with
the selected value displays, along with rows of other values not selected.
The subsequent rows with the selected value are not moved to the top, but
reside within the remaining rows.
COLUMN Putting autofilter on this column and seleting for Bob:
COLUMN
Bob
Eric
Bob
Bob
Bob
Steve
Bob
Steve
Bob
Tom
Tom
and the adjacent column is blank (except for the header). With autofilter
on, a value is selected from the drop down box. The first set of rows with
the selected value displays, along with rows of other values not selected.
The subsequent rows with the selected value are not moved to the top, but
reside within the remaining rows.
COLUMN Putting autofilter on this column and seleting for Bob:
COLUMN
Bob
Eric
Bob
Bob
Bob
Steve
Bob
Steve
Bob
Tom
Tom