Advanced Filter Causes Crash

[flipnello]

When I try to use an advanced filter on a fairly large list (500+ rows)
I get the error message: "EXCEL.exe has genereated problems and will b
closed by Windows." I've noticed that the list actually does ge
filtered successfully, but excel always crashes immediately after.

I have around 100 rows of criteria. ( I have a list of about 70
account numbers in one coloumn and their corresponding GL codes in th
next column, and I'm trying to filter only the numbers that I'm payin
in a given period (the 100 rows of criteria).

I'm running excel 2000 on win 2000. This is the only crashing proble
I've had. If I could get Advanced Filter to work, it would save me
bundle of time - I hope someone has an idea...

Thanks

 

[Debra Dalgleish]

It should work, but you could try the following instead:

Add a column to the table
In the heading cell, type: Filter
In the cell below (A2 in this example), enter a COUNTIF formula that
refers to your criteria range, e.g.: =COUNTIF($N$2:$N$101,A2)
Choose Data>Filter>AutoFilter
Filter the new column for 1

 

[Bernie Deitrick]

Fliip,

You could try using a "helper" column, where you use a formula like

=NOT(ISERROR(MATCH(A1,$B$1:$B$100,FALSE)))

copied down to match your data ( in column A ) and then use autofilter on
that column, showing only the TRUE values.

HTH,
Bernie
MS Excel MVP