I need to find the minimum value in a date range in my spreadsheet.
The worksheet has 17691 records, each record represents a 15 minute (in chronological order) snapshot for the value we're recording. That equals to about 6 months worth of 15 minute snapshots.
What I need to do is find the minimum value for the last 30 days of the worksheet.
Example:
The date range is 8/1/2008 through 2/1/2009. I need to find the lowest number in the last 30 days (1/1/2009-2/1/2009) of the data.
It would be even better if I could find the lowest number based on the last MONTH (to compenstate for months that have more or less than 30 days).
I hope I explained my problem clearly, and I think you all for any help you can offer!
The Titanic was built by engineers. The Ark was built by an amateur.
The worksheet has 17691 records, each record represents a 15 minute (in chronological order) snapshot for the value we're recording. That equals to about 6 months worth of 15 minute snapshots.
What I need to do is find the minimum value for the last 30 days of the worksheet.
Example:
The date range is 8/1/2008 through 2/1/2009. I need to find the lowest number in the last 30 days (1/1/2009-2/1/2009) of the data.
It would be even better if I could find the lowest number based on the last MONTH (to compenstate for months that have more or less than 30 days).
I hope I explained my problem clearly, and I think you all for any help you can offer!
The Titanic was built by engineers. The Ark was built by an amateur.