Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select / Filter Data
Hi All,
I have in my sheet1 Four fields Name, Date1, Date2 and Date3. How can I select/filter the data to get the list of data within a specific date? For Eg. If I select 15-1-2003 then All records which is before the given date should list.. my filter should check date1,date2,date3 and if any of them is before the date then that record should be selected. I think in filter there is only two criterea. TIA Soniya |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select / Filter Data
You should use the Advanced Filter for this job. I can send you an example
upon request. "Soniya" wrote in message ... Hi All, I have in my sheet1 Four fields Name, Date1, Date2 and Date3. How can I select/filter the data to get the list of data within a specific date? For Eg. If I select 15-1-2003 then All records which is before the given date should list.. my filter should check date1,date2,date3 and if any of them is before the date then that record should be selected. I think in filter there is only two criterea. TIA Soniya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select All Auto Filter | Excel Discussion (Misc queries) | |||
How to select item without using advanced filter? | Excel Discussion (Misc queries) | |||
Excel data filter collapses rows even after I select show all!?!?!? | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Select from/filter | Excel Programming |