LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 57
Default Create a dynamic list

I have a table with columns for Expiration Date, Address, , Certificate
Number, and various other data. I wish to create a list on another tab based
on criteria. For example, I would like a list of all the Certificates that
expire in the next 30 days, 31-60 days, expired, good... I have a column
calculation the time to expiration. Can someone please tell me how to
proceed from here.

Thanks
steve

Status Exp Date CO Number
Expired 3/23/2007 948
Expired 5/28/2007 949
Good 3/27/2108 950
Expired 4/28/2007 951
Expired 7/25/2007 952
Expired 7/27/2007 953
Expired 5/30/2007 954
30 Days 12/30/2008 955

 
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
Changing named Validation list to Dynamic list. GlenC Excel Discussion (Misc queries) 1 July 20th 06 11:49 PM
How to create a 'dynamic' formula? Bill Excel Worksheet Functions 11 April 22nd 06 07:18 PM
How do I create a dynamic chart Nick Krill Charts and Charting in Excel 5 January 21st 06 08:25 PM
Can't create dynamic charts Brian Sells Charts and Charting in Excel 7 March 22nd 05 04:23 AM
how to create a dynamic descending list of months & years marika1981 Excel Discussion (Misc queries) 6 February 19th 05 03:57 AM


All times are GMT +1. The time now is 04:23 AM.

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

About Us

"It's about Microsoft Excel"