Cell reference in the auto filter custom list

A

Andre Croteau

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top