Problems with Auto Filter

C

ChemicalJasper

Dear All,

Is anyone aware of any problems with (and know of any ideas /
patches / fixes) with Auto Filter on Excel 2003 (11.6355.6360) SP1
operating under XP SP2.

I have a spreadsheet with around 30 columns and 4000 rows. Most
columns are manually enetered data, a few are calculated values, based
on the data in the manual data in that row.

The problem am having is that when I use auto filter, both when
choosing just a row and selecting auto filter (so the whole sheet is
filtered) or selecting just the data in the table, auto filter is
messing with my rows!

It seems to only filter across half the columns and then selects other
data for the remaining colums.

The odd thing is that the conditional formatting remains correct for
the rows filtered, but the data is incorrect (has been selected from a
different and not visible row).

Anyone seen this before? Have any ideas?

Thanks,

Steve
 
C

challa prabhu

Hi,

Yes: Treat excel as as database, and execute query.

Specify this procedure for two different ranges:

Copy all the columns to a single excle sheet. This
is basicall to run an advance query which will fetch you all the information
for you to compare. I shall explain you how to do it.

Assuming that you have copied all the columns to a single spread sheet, you
know the column heading now, save the excel sheet.

Now I wiil be using the Advance filtering techniques so that all the column
information are retrieved even if the typed cells are misspelled, which
normally is not the case when you do a simple filtering technique. The
filtered values may not be correct.

To retieve the values;

1. Select all records and the column headings and define a name for the
range List. This is the List range name.
2. Select all column headings and paste in a seperate row anywhere in the
spreadsheet.
2. Select the pasted column heading along with an empty row and define a
name. This is the criteria range name.
3. Define a criteria on the second row for all columns, if necessary. For
example S* will display all details specific to "S'.
4. Click Data-> Filter-> Advanced Filter
5. Type the List name
6. Type the Criteria Name
7. Click copy to another location option - Mandatory
8. Click Copy to
9. Click the cell below the criteria range

All data will be displayed specific to the query you requested. This is very
usefull if the spreadsheet data are mistyped or mis-spelled. Now you have
done a database funtion on your excle spread sheet.

Challa Prabhu
 
C

ChemicalJasper

Hi,

Yes: Treat excel as as database, and execute query.

Specify this procedure for two different ranges:

Copy all the columns to a single excle sheet. This
is basicall to run an advance query which will fetch you all the information
for you to compare. I shall explain you how to do it.

Assuming that you have copied all the columns to a single spread sheet, you
know the column heading now, save the excel sheet.

Now I wiil be using the Advance filtering techniques so that all the column
information are retrieved even if the typed cells are misspelled, which
normally is not the case when you do a simple filtering technique. The
filtered values may not be correct.

To retieve the values;

1. Select all records and the column headings and define a name for the
range List. This is the List range name.
2. Select all column headings and paste in a seperate row anywhere in the
spreadsheet.
2. Select the pasted column heading along with an empty row and define a
name. This is the criteria range name.
3. Define a criteria on the second row for all columns, if necessary. For
example S* will display all details specific to "S'.
4. Click Data-> Filter-> Advanced Filter
5. Type the List name
6. Type the Criteria Name
7. Click copy to another location option - Mandatory
8. Click Copy to
9. Click the cell below the criteria range

All data will be displayed specific to the query you requested. This is very
usefull if the spreadsheet data are mistyped or mis-spelled. Now you have
done a database funtion on your excle spread sheet.

Challa Prabhu











- Show quoted text -

Thanks Challa, loads of detail there to help me!

Steve
 

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