Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel Advanced Filter
Name: clomper Date: February 10, 2004 at 12:02:32 Pacific OS: winxp CPU/Ram: 2.8/512
Comment:
I have a cell on a worksheet named "EDATE". In this cell is a date that corresponds to the date of the end of a week. The data table below contains a column for entry dates, with the named range "ENTRYDATES". I want to filter all records for a given week based on the date entered in EDATE. I've setup advanced filter criteria rows, and under the "Entry Dates" heading I've tried this formula: =(EDATE-8)<ENTRYDATES<EDATE But it won't filter. Will Excel allow the use of named ranges in filter criteria? If so, how do you correctly enter a formula? Thanks!
Name: gieskebam Date: February 10, 2004 at 12:41:15 Pacific
Reply:
Excel doesn't filter in runtime. Either by hand: with a cutom filter Or by Visual Basic Applications where you fill in the filter criteria by the push of a button
Summary: could you please tell me hot to perform (Advanced Filter) in Ms Excel 2003 data menu and what are its benifits Abdul Naseer Ansari Afghanistan...
Summary: Hi, I have a problem, I have a column (lets say column A) in Excel that contains data of type date, I converted it to date using the formula DateValue, now I need to enter a cretirea in the advanced f...
Summary: I have a Excel 2003 file that has 8 worksheets with about 45,000 lines of data in each worksheet. The data is an employee list with hours worked, employee number, total amount paid, last name, and fi...
0 
