Cell reference in the auto filter custom list

[Andre Croteau]

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 =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]

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.