| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
user defined date
I have a spreadsheet that calculates stats on a data series that starts
in 1985 and ends in 2004. Rather than always seeing the stats for the fixed time period of 1/85-12/04, I would like to be able to enter the start and end date and receive stats for the specified time period. Any ideas on how to do this? |
|
#2
|
|||
|
|||
|
I think the easiest way would be to switch on AutoFilter and Filter on the
date field Regards Trevor wrote in message oups.com... I have a spreadsheet that calculates stats on a data series that starts in 1985 and ends in 2004. Rather than always seeing the stats for the fixed time period of 1/85-12/04, I would like to be able to enter the start and end date and receive stats for the specified time period. Any ideas on how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
| user defined formats for small numbers | Excel Discussion (Misc queries) | |||
| User defined charts- font size too small | Charts and Charting in Excel | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| how to move user defined function | Excel Worksheet Functions | |||
Linear Mode
