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.
Advanced Filters in Excel
Name: Dinka Date: February 18, 2004 at 13:43:46 Pacific OS: win XP CPU/Ram: 256
Comment:
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 filter that will mean return all rows that are greater from a certain date, how can I do that?
Name: chnos Date: February 19, 2004 at 00:12:35 Pacific
Reply:
select column, autofilter, choose custom, put "greater than" "date to be compared" and validate. Where's the prob...?
0
Response Number 2
Name: Dinka Date: February 19, 2004 at 01:00:59 Pacific
Reply:
Hi,
I need to use the advanced filter because I have other cretirea that cannot be entered in the auto filter
Regards, Dina
0
Response Number 3
Name: chnos Date: February 19, 2004 at 04:20:02 Pacific
Reply:
maybe it can be done with a pivot table and make ur filter in it ( i haven't yet tried it with ur case) Either why don't u add a hidden conditionned row right ur date to bring up ur 1st condition and nextfilter on it..?
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: I'm thinking the only way to do this is with a User Defined Function. As it turns out, I found one that seems to work. Here's what I did: I put your table in A1:A8 I created an Advanced Filter in B1, ...
Summary: 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 "ENTR...
0 
