Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing named Validation list to Dynamic list. | Excel Discussion (Misc queries) | |||
How to create a 'dynamic' formula? | Excel Worksheet Functions | |||
How do I create a dynamic chart | Charts and Charting in Excel | |||
Can't create dynamic charts | Charts and Charting in Excel | |||
how to create a dynamic descending list of months & years | Excel Discussion (Misc queries) |