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!
|
Similar Threads
