MrExcel Publishing
Your One Stop for Excel Tips & Solutions

getting there...


Posted by laura jean on February 05, 2002 11:05 AM

OK, when a cell between rows 69:72 "begins with" "vol"
row 73 contains a number representing a volume. There
are other numbers in row 73 that I filter out
with:
=IF((OR(EXACT("vol",LEFT(G69:G72,3)))),G$73,"")

That array formula, Filled across row 74, successfully
produces a row of volumes and blank cells! ***
BUT when I try to plot that, the blank cells appear as
ZEROs (I checked the "Plot visible cells only" Option)


Posted by Mark W. on February 05, 2002 11:09 AM

Why aren't you using an AutoFilter?

Posted by laura jean on February 05, 2002 11:17 AM

Re: Why aren't you using an AutoFilter?

Was is das???

Posted by Mark W. on February 05, 2002 11:26 AM

See the Data | Filter | AutoFilter menu command [NT]

Posted by laura jean on February 05, 2002 11:58 AM

can I tranpose the AutoFilter?


Posted by Mark W. on February 05, 2002 12:05 PM

Not sure what you mean...AutoFilters are applied to columns [NT]


Posted by laura jean on February 05, 2002 12:07 PM

You got it... can one apply AutoFilters to rows?

Posted by Mark W. on February 05, 2002 12:43 PM

Semantics...

The AutoFilter itself is assigned to a column and
it "filters" rows. Rows that match the AutoFilter
criteria are displayed. So if you filter for
"begins with" "vol" only your vol rows are displayed.
Excel graphs exclude values obtained from a
filtered list that are not displayed.

Posted by laura jean on February 05, 2002 1:00 PM

OK, so I've transposed my data...

and you have ushered me into the bright new world
of excell Filters. I am trying various ways to
display my (now) rows of data with cells that
"begin with" "vol" in ANY of the first 4 columns.
I thought it might work using "advanced filter"
if I put "vol*" in each column, on separate rows
in my criteria range... which I put directly above
my data. And I added column labels above the
criteria range.

Posted by laura jean on February 05, 2002 1:18 PM

YIPPIEEEE!!!! got it to work ==thanks==