software

Hello,I have data tables in cells A115, and have organised the auto filters in
the header cells A1 to D1
In cells X1 and Z1, I have the values =month(now()) and
month(date(year(now()),month(now()) 1,1)) respectively

Is it possible to organise the auto filter from cell D1 to have the
following custom auto filter:

1) equal to = X1 ( i.e. whatever is located in cell
X1)

and

2) equal to =Z1I tried this without success, and also tried to put the actual formulas in
the custom format boxes, but it didn't work either

It there a way to do this?

Thanks

André
You can't do it in the custom autofilter, but you could add another two
columns to your table, and enter the formulas there. For example:

Test1 Test2
=$X$1 =$Z$1

Copy the formulas down to the last row of data.
Then, filter those columns for true or false.

Andre Croteau wrote:
gt; Hello,
gt;
gt;
gt; I have data tables in cells A115, and have organised the auto filters in
gt; the header cells A1 to D1
gt; In cells X1 and Z1, I have the values =month(now()) and
gt; month(date(year(now()),month(now()) 1,1)) respectively
gt;
gt; Is it possible to organise the auto filter from cell D1 to have the
gt; following custom auto filter:
gt;
gt; 1) equal to = X1 ( i.e. whatever is located in cell
gt; X1)
gt;
gt; and
gt;
gt; 2) equal to =Z1
gt;
gt;
gt; I tried this without success, and also tried to put the actual formulas in
gt; the custom format boxes, but it didn't work either
gt;
gt; It there a way to do this?
gt;
gt; Thanks
gt;
gt; André
gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html