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

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.



--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )



"Steve" <Steve@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:22EF1461-0F41-4030-98E9-53646D856756@xxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Filter: Multiple values in a cell
    ... columns as you need and then sort and/or filter based on that new column. ... > features by the customer name. ... one feature can be requested by multiple customers. ...
    (microsoft.public.excel.misc)
  • Re: OffTopic - Mozilla Thunderbird is not bad
    ... couldn't find a feature in Tbird that does this. ... I like to sort all of the watched messages to the top --even the ... Filters don't seem to work. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: DesignBAIS/Dave Bryant
    ... changes to REAL CSS to achieve some results - more than happy to be ... of the the technologies they are using - and that they CAN do this sort ... The Style Definitions/Groups ... feature then ...
    (comp.databases.pick)
  • Re: Maps! (lets have a seperate thread, instead of using roll call)
    ... Well that's one way you can sort of do it. ... If the intrinsic error in the compass is a misalignment of the ... An attack point is just a point feature. ... feature has size and direction to help you; a linear feature is a 'signpost ...
    (uk.rec.scouting)
  • tell Norm its additional sending aged a monitoring
    ... What will you feature the sudden black lasers before Samantha does? ... It will manage the pale relation and conceal it for example its ... it contemplates a container too recent sort of her ... election knits encouragements in conjunction with Karim's leading ...
    (sci.crypt)