software

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.

ThanksNo. 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

gt; wrote in message ups.com...
gt; Is there any way to autofilter some different ranges for
gt; nonblank cells
gt; at different vertical points on a sheet?
gt;
gt; I dont normally use this type of thing, but it needs to be
gt; automatic as
gt; the data coming in will change.
gt;
gt; Specifically I want to filter a list of data (5500 entries) to
gt; show
gt; only those rows with data in a certain column, and at the
gt; bottom in a
gt; seperate Split, do it again.
gt;
gt; Thanks
gt;
Darn it. Thanks anyway.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=quot;Aquot;,ROW($A$1:$A$ 6000)),ROW()-ROW(D$1) 1)),quot;quot;,INDEX(B$1:B$6000,SMALL(IF($A$1:$A$ 6000=quot;Aquot;,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