School teacher needs help! Need to filter all columns, not just o

S

Steve

I have a list of students with their grades. I filter one of the grade
columns into ascending order of grades. But it just sorts that column while
all the others stay put. I want the whole lot to move together for the
obvious reason that I don't want the marks to be misallocated to the wrong
students!
eg TO FILTER into ascending order by COLUMN 2:

START WITH
Column 1 Column 2
Bob Smith C C
Sue Brown C B
Nancy Drew D A

SHOULD READ

Nancy Drew D A
Sue Brown C B
Bob Smith C C

NOT
Bob Smith C A
Sue Brown C B
Nancy Drew D C

Note I am using the FILTER function not the SORT funtion per se
 
A

Arvi Laanemets

Hi


Your explanation is somehow messy! What do you do exactly?

When you apply AutoFilter feature (Data>Filter>AutoFilter) to your table,
then you don't sort anything - you only hide all rows not matching the
filter condition;
When you apply Advanced Filter feature (Data>Filter>AdvancedFilter) , then
you hide non-matchin rows again, or you copy matching rows to new location;
When you want to sort your table, use Sort feature (Data>Sort) instead.
(Select a single cell from your table, when there are no gaps (fully empty
rows or columns) in your table, or select the whole table before sorting -
when you select a non-single cell part of table instead, only this part will
be sorted);
When you want to copy rows matching some condition to new location sorted by
some column, and you need this as one-time action, sort your table before,
and then apply Advanced Filter;
When you need some part of your table matching some condition to be
displayed in new location, and sorted differently as source data, and
updatable, then use an ODBC Query: Create a named range which includes your
whole table including column headers (you MUST have an header row), and use
this named range as source table for ODBC query. In query properties, you
can set the query to be refreshed automatically after given time interval,
and/or on Open event - and you can refresh it manually too.
 
F

Fred Smith

"Note I am using the FILTER function not the SORT funtion per se"

That's your problem. Don't use Filter, use Data>Sort... Make sure you select the
entire table you want sorted, or, as most people do, just make sure the active
cell is somewhere in your table. Sort will normally figure out the appropriate
table to sort.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top