Consecutive values; averages and ranges by specific months

E

Emilio

Right off the bat I want to thank everyone for their help in these
boards. It's an amazing resource. I have a big spreadsheet with daily
values over time.

I want to see for how many CONSECUTIVE days the value was over 90, and
also to get the range where that happened. So if I get a maximum value
for the consecutive days, can I also get the range of where that
happened in the spreadsheet?

Also, Is there an easy way to get, for example, the averages for a
month. I have the values in both MM/DD/YY in a single cell and also
one individual column for each month day and year (so 06/26/1968) and
one column each for 6, 26 and 1968, respectively. The values are in a
separate column.

Many thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consecutive values; Averages for a single month. 2
Finding location (or start cell) of highest consecutive values 3
Best 3 Consecutive Months 13
location of highest consecutive values 0
Row reference for consecutive series calculation 0
Problem with formula for finding last greater than/less than or equal to value 2
Word macro that can call cells out of Excel for a find and replace 0
Add 2 days before and after birthdate 4

Top