Cell reference in the auto filter custom list
 

Hello,


I have data tables in cells A1:D15, 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 =Z1


I 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é

Cell reference in the auto filter custom list
 

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:
Hello,


I have data tables in cells A1:D15, 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 =Z1


I 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é




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html