Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
LV
 
Posts: n/a
Default How do I filter a list using a greater than todays date function?

I'd like users to be able to view data in a worksheet by anything greater
than todays date. How do I do this without sorting the sheet myself? I'd like
to customize an autofilter but it seems that I have to go in and define the
custom filter everytime I want to re-filter the data. And I can't seem to
figure out how to do it using the advanced filter.

Any suggestions?
  #2   Report Post  
patrick
 
Posts: n/a
Default

=IF(A1TODAY(),A1,"")
This will automatically "hide" the dates earlier than "Today". You may want
to hide the date column-or you may want to use the spreadsheet and have the
results with this filtering formula on a 2nd display tab!
Pat

"LV" wrote:

I'd like users to be able to view data in a worksheet by anything greater
than todays date. How do I do this without sorting the sheet myself? I'd like
to customize an autofilter but it seems that I have to go in and define the
custom filter everytime I want to re-filter the data. And I can't seem to
figure out how to do it using the advanced filter.

Any suggestions?

  #3   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

LV,

Simplest to do would be add a 'helper" column, with a formula like

=A1NOW()

where A1 has a date (then copy the formula down to match your data). Then
you can filter your list based on that column, for TRUE values. You will
need to re-filter to get it to update properly, but that should be easy.

HTH,
Bernie
MS Excel MVP


"LV" wrote in message
...
I'd like users to be able to view data in a worksheet by anything greater
than todays date. How do I do this without sorting the sheet myself? I'd

like
to customize an autofilter but it seems that I have to go in and define

the
custom filter everytime I want to re-filter the data. And I can't seem to
figure out how to do it using the advanced filter.

Any suggestions?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to filter and list data based on different data. Defoes Right Boot Excel Worksheet Functions 3 April 13th 05 04:03 PM
Excel List range, filter arrows disappeared andrew Excel Discussion (Misc queries) 3 April 1st 05 11:30 PM
Product Price List with 14k records, filter w/out using AutoFilter ChrisSeattle Excel Worksheet Functions 1 March 3rd 05 07:46 PM
FILTER OUT DATES IN LIST Lisa Excel Worksheet Functions 1 January 31st 05 03:17 PM
Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . Dan W Excel Worksheet Functions 0 December 1st 04 04:53 PM


All times are GMT +1. The time now is 02:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"