Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering Based on External Criteria
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering Based on External Criteria
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" -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Youlan" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering by criteria within PV in Excel. | Excel Discussion (Misc queries) | |||
Filtering using ends with decimal criteria | Excel Worksheet Functions | |||
Filtering External Data | Excel Worksheet Functions | |||
Filtering by criteria in two columns | Excel Worksheet Functions | |||
Advanced Filtering - Computed Criteria | Excel Worksheet Functions |