Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced filter
Hi,
XL 2003 I am having trouble using Advanced Filter. Column A has Dates (formatted as date), and Column B has Names. I want to filter on the basis of any date being between Today and 7 days later. Not having success with this, I tried just filtering on anything greater than Today. In the criteria range, I have: ="TODAY()" But when I applied the filter, no filtering takes place. All dates are shown. I haven't used advanced filter before. What am I doing wrong? Regards - Dave. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced filter
Try this...
=""&TODAY()+7 -- Biff Microsoft Excel MVP "Dave" wrote in message ... Hi, XL 2003 I am having trouble using Advanced Filter. Column A has Dates (formatted as date), and Column B has Names. I want to filter on the basis of any date being between Today and 7 days later. Not having success with this, I tried just filtering on anything greater than Today. In the criteria range, I have: ="TODAY()" But when I applied the filter, no filtering takes place. All dates are shown. I haven't used advanced filter before. What am I doing wrong? Regards - Dave. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced filter
Try:
=""&TODAY() It'll look funny. You'll see a 5 digit number, but should work ok. ps. I'd look at Debra Dalgleish's site for tips with advanced filter. http://contextures.com/xladvfilter01.html and http://contextures.com/tiptech.html Dave wrote: Hi, XL 2003 I am having trouble using Advanced Filter. Column A has Dates (formatted as date), and Column B has Names. I want to filter on the basis of any date being between Today and 7 days later. Not having success with this, I tried just filtering on anything greater than Today. In the criteria range, I have: ="TODAY()" But when I applied the filter, no filtering takes place. All dates are shown. I haven't used advanced filter before. What am I doing wrong? Regards - Dave. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced filter
I want to filter on the basis of any date being
between Today and 7 days later. Ooops! I missed the double criteria. Try this... Assume the column header is named Date. As the criteria enter this in the criteria range: .............Date...........................Date ="="&TODAY()........="<="&TODAY()+7 -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this... =""&TODAY()+7 -- Biff Microsoft Excel MVP "Dave" wrote in message ... Hi, XL 2003 I am having trouble using Advanced Filter. Column A has Dates (formatted as date), and Column B has Names. I want to filter on the basis of any date being between Today and 7 days later. Not having success with this, I tried just filtering on anything greater than Today. In the criteria range, I have: ="TODAY()" But when I applied the filter, no filtering takes place. All dates are shown. I haven't used advanced filter before. What am I doing wrong? Regards - Dave. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced filter
Thanks gentlemen!
Dave. "Dave Peterson" wrote: Try: =""&TODAY() It'll look funny. You'll see a 5 digit number, but should work ok. ps. I'd look at Debra Dalgleish's site for tips with advanced filter. http://contextures.com/xladvfilter01.html and http://contextures.com/tiptech.html Dave wrote: Hi, XL 2003 I am having trouble using Advanced Filter. Column A has Dates (formatted as date), and Column B has Names. I want to filter on the basis of any date being between Today and 7 days later. Not having success with this, I tried just filtering on anything greater than Today. In the criteria range, I have: ="TODAY()" But when I applied the filter, no filtering takes place. All dates are shown. I haven't used advanced filter before. What am I doing wrong? Regards - Dave. -- Dave Peterson . |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced filter
Hi Biff,
Yeah, thanks for that. I picked that up off Deborah Dalgeish's site - the AND being criteria on the same row, and the OR being on different rows. But she was using actual dates in her example, so she used 1/11/01 and <1/25/01, without any quote marks, which didn't work when I used the TODAY() function; hence my original post. Regards - Dave. "T. Valko" wrote: I want to filter on the basis of any date being between Today and 7 days later. Ooops! I missed the double criteria. Try this... Assume the column header is named Date. As the criteria enter this in the criteria range: .............Date...........................Date ="="&TODAY()........="<="&TODAY()+7 -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this... =""&TODAY()+7 -- Biff Microsoft Excel MVP "Dave" wrote in message ... Hi, XL 2003 I am having trouble using Advanced Filter. Column A has Dates (formatted as date), and Column B has Names. I want to filter on the basis of any date being between Today and 7 days later. Not having success with this, I tried just filtering on anything greater than Today. In the criteria range, I have: ="TODAY()" But when I applied the filter, no filtering takes place. All dates are shown. I haven't used advanced filter before. What am I doing wrong? Regards - Dave. . |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced filter
Good deal. Lot's of good stuff on Deborah's site. I refer people to it
often. Thanks for the feedback! -- Biff Microsoft Excel MVP "Dave" wrote in message ... Hi Biff, Yeah, thanks for that. I picked that up off Deborah Dalgeish's site - the AND being criteria on the same row, and the OR being on different rows. But she was using actual dates in her example, so she used 1/11/01 and <1/25/01, without any quote marks, which didn't work when I used the TODAY() function; hence my original post. Regards - Dave. "T. Valko" wrote: I want to filter on the basis of any date being between Today and 7 days later. Ooops! I missed the double criteria. Try this... Assume the column header is named Date. As the criteria enter this in the criteria range: .............Date...........................Date ="="&TODAY()........="<="&TODAY()+7 -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this... =""&TODAY()+7 -- Biff Microsoft Excel MVP "Dave" wrote in message ... Hi, XL 2003 I am having trouble using Advanced Filter. Column A has Dates (formatted as date), and Column B has Names. I want to filter on the basis of any date being between Today and 7 days later. Not having success with this, I tried just filtering on anything greater than Today. In the criteria range, I have: ="TODAY()" But when I applied the filter, no filtering takes place. All dates are shown. I haven't used advanced filter before. What am I doing wrong? Regards - Dave. . |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced filter
I would expect 1/11/01 to look for a value greater than (one divided by
fifteen then divided by one). Are you sure that you saw that on Deborah's site? Could you give us the URL of the relevant page, please? -- David Biddulph "Dave" wrote in message ... Hi Biff, Yeah, thanks for that. I picked that up off Deborah Dalgeish's site - the AND being criteria on the same row, and the OR being on different rows. But she was using actual dates in her example, so she used 1/11/01 and <1/25/01, without any quote marks, which didn't work when I used the TODAY() function; hence my original post. Regards - Dave. "T. Valko" wrote: I want to filter on the basis of any date being between Today and 7 days later. Ooops! I missed the double criteria. Try this... Assume the column header is named Date. As the criteria enter this in the criteria range: .............Date...........................Date ="="&TODAY()........="<="&TODAY()+7 -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this... =""&TODAY()+7 -- Biff Microsoft Excel MVP "Dave" wrote in message ... Hi, XL 2003 I am having trouble using Advanced Filter. Column A has Dates (formatted as date), and Column B has Names. I want to filter on the basis of any date being between Today and 7 days later. Not having success with this, I tried just filtering on anything greater than Today. In the criteria range, I have: ="TODAY()" But when I applied the filter, no filtering takes place. All dates are shown. I haven't used advanced filter before. What am I doing wrong? Regards - Dave. . |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced filter
Of course I meant eleven, not fifteen. Too early in the morning. :-(
-- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... I would expect 1/11/01 to look for a value greater than (one divided by fifteen then divided by one). Are you sure that you saw that on Deborah's site? Could you give us the URL of the relevant page, please? -- David Biddulph "Dave" wrote in message ... Hi Biff, Yeah, thanks for that. I picked that up off Deborah Dalgeish's site - the AND being criteria on the same row, and the OR being on different rows. But she was using actual dates in her example, so she used 1/11/01 and <1/25/01, without any quote marks, which didn't work when I used the TODAY() function; hence my original post. Regards - Dave. "T. Valko" wrote: I want to filter on the basis of any date being between Today and 7 days later. Ooops! I missed the double criteria. Try this... Assume the column header is named Date. As the criteria enter this in the criteria range: .............Date...........................Date ="="&TODAY()........="<="&TODAY()+7 -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this... =""&TODAY()+7 -- Biff Microsoft Excel MVP "Dave" wrote in message ... Hi, XL 2003 I am having trouble using Advanced Filter. Column A has Dates (formatted as date), and Column B has Names. I want to filter on the basis of any date being between Today and 7 days later. Not having success with this, I tried just filtering on anything greater than Today. In the criteria range, I have: ="TODAY()" But when I applied the filter, no filtering takes place. All dates are shown. I haven't used advanced filter before. What am I doing wrong? Regards - Dave. . |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced filter
Hi,
The link is: http://contextures.com/xladvfilter01.html Then click f) Criteria Examples Dave. "David Biddulph" wrote: I would expect 1/11/01 to look for a value greater than (one divided by fifteen then divided by one). Are you sure that you saw that on Deborah's site? Could you give us the URL of the relevant page, please? -- David Biddulph "Dave" wrote in message ... Hi Biff, Yeah, thanks for that. I picked that up off Deborah Dalgeish's site - the AND being criteria on the same row, and the OR being on different rows. But she was using actual dates in her example, so she used 1/11/01 and <1/25/01, without any quote marks, which didn't work when I used the TODAY() function; hence my original post. Regards - Dave. "T. Valko" wrote: I want to filter on the basis of any date being between Today and 7 days later. Ooops! I missed the double criteria. Try this... Assume the column header is named Date. As the criteria enter this in the criteria range: .............Date...........................Date ="="&TODAY()........="<="&TODAY()+7 -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this... =""&TODAY()+7 -- Biff Microsoft Excel MVP "Dave" wrote in message ... Hi, XL 2003 I am having trouble using Advanced Filter. Column A has Dates (formatted as date), and Column B has Names. I want to filter on the basis of any date being between Today and 7 days later. Not having success with this, I tried just filtering on anything greater than Today. In the criteria range, I have: ="TODAY()" But when I applied the filter, no filtering takes place. All dates are shown. I haven't used advanced filter before. What am I doing wrong? Regards - Dave. . . |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advanced filter
Yes, OK, I'm surprised!
I must admit that Advanced Filter is something that I don't normally use. I tend to stick to AutoFilter, but hopefully this'll persuade me to lok at Debra's site and learn more about Advanced Filter. -- David Biddulph "Dave" wrote in message ... Hi, The link is: http://contextures.com/xladvfilter01.html Then click f) Criteria Examples Dave. "David Biddulph" wrote: I would expect 1/11/01 to look for a value greater than (one divided by fifteen then divided by one). Are you sure that you saw that on Deborah's site? Could you give us the URL of the relevant page, please? -- David Biddulph "Dave" wrote in message ... Hi Biff, Yeah, thanks for that. I picked that up off Deborah Dalgeish's site - the AND being criteria on the same row, and the OR being on different rows. But she was using actual dates in her example, so she used 1/11/01 and <1/25/01, without any quote marks, which didn't work when I used the TODAY() function; hence my original post. Regards - Dave. "T. Valko" wrote: I want to filter on the basis of any date being between Today and 7 days later. Ooops! I missed the double criteria. Try this... Assume the column header is named Date. As the criteria enter this in the criteria range: .............Date...........................Date ="="&TODAY()........="<="&TODAY()+7 -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this... =""&TODAY()+7 -- Biff Microsoft Excel MVP "Dave" wrote in message ... Hi, XL 2003 I am having trouble using Advanced Filter. Column A has Dates (formatted as date), and Column B has Names. I want to filter on the basis of any date being between Today and 7 days later. Not having success with this, I tried just filtering on anything greater than Today. In the criteria range, I have: ="TODAY()" But when I applied the filter, no filtering takes place. All dates are shown. I haven't used advanced filter before. What am I doing wrong? Regards - Dave. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter - filter rows < | Excel Discussion (Misc queries) | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |