Filtering Based on External Criteria

  • Thread starter Thread starter Youlan
  • Start date Start date
Y

Youlan

Hi,

I'm trying to filter a column named "Maturity Date" as follows:

The filter would be for items less than a date which would be in a cell in
another spreadsheet or at least in a cell outside of the filter range.

I would greatly appreciate any help with this.

Thanks in advance.
 
Create a helper col to flag that criteria, then autofilter on that helper col

Eg if that criteria date is entered in say, Sheet2's A1
In the source Sheet1, where dates are running in A2 down
you could place in B2: =IF(A2="","",IF(A2<Sheet2!$A$1,"Y",""))
and copy B2 down to the last row of dates in col A.
Then autofilter on col B for "Y"
 
You must log in or register to reply here.

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

Similar Threads

Macro filter based on date criteria 4
Hlp! Named range Advanced Filter Criterion 10
Advanced filter 7
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 2
Filter 1
advanced filtering multiple criteria 2
Dynamic Filtering 2
Advanced Filter when using Date Range Cells 3

Back
Top