Any way to autofilter at seperate points on the same sheet?

[theseandavis]

Is there any way to autofilter some different ranges for nonblank cells
at different vertical points on a sheet?

I dont normally use this type of thing, but it needs to be automatic as
the data coming in will change.

Specifically I want to filter a list of data (5500 entries) to show
only those rows with data in a certain column, and at the bottom in a
seperate Split, do it again.

Thanks

 

[Chip Pearson]

No. AutoFilter works on an entire sheet. You can't have separate
AutoFilter regions.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[theseandavis]

Darn it. Thanks anyway.

 

[vezerid]

You can implement such a filter with formulas. For example, you can
compute the cells of the seocnd column that meet your condition for A
as follows:

=IF(ISERROR(SMALL(IF($A$1:$A$6000="A",ROW($A$1:$A$6000)),ROW()-ROW(D$1)+1)),"",INDEX(B$1:B$6000,SMALL(IF($A$1:$A$6000="A",ROW($A$1:$A$6000)),ROW()-ROW(D$1)+1)))

(Array formula, use Shift+Ctrl+Enter to commit)

This formula assumes that your output data start at cell D1, with the
second column (B1:B6000) of your data. It assumes your data is in
A1:B6000.

You can copy this formula down and across. If you place, for example
this formula in B$6001 you can have your filter below your data as they
change. This is a moderately heavy formula, it was tested against two
columns of input data and 6000 rows. The formula was copied down 670
rows. Recalculation time was acceptable.

HTH
Kostis Vezerides