luftikus143
New Member
- Joined
- Feb 25, 2010
- Messages
- 5
Hi,
I am struggling quite a bit to find a solution; I am sure it's out there, but I just don't find it (or get it). I am even not sure what really to search for...
I have something like this:
<colgroup><col span="3"></colgroup><tbody>
</tbody>
which continues till Day is 365, and then it start with 1980 and Day 1 again:
<colgroup><col span="3"></colgroup><tbody>
</tbody>
This continues till recently (2015).
Now, I would like to calculate the MIN value for each year over these 365 days, and put these in the following column, in order to have something like this:
<colgroup><col><col></colgroup><tbody>
</tbody>
I thought something like MIN(OFFSET(xxxx)) could do it. But I just couldn't figure out how...
Thanks for any hints how to achieve this.
I am struggling quite a bit to find a solution; I am sure it's out there, but I just don't find it (or get it). I am even not sure what really to search for...
I have something like this:
Year | Day | Value |
1979 | 1 | 26.405 |
1979 | 2 | 26.496 |
1979 | 3 | 26.582 |
1979 | 4 | 26.672 |
1979 | 5 | 26.770 |
1979 | 6 | 26.867 |
<colgroup><col span="3"></colgroup><tbody>
</tbody>
which continues till Day is 365, and then it start with 1980 and Day 1 again:
1979 | 365 | 24.934 |
1980 | 1 | 25.039 |
1980 | 2 | 25.147 |
1980 | 3 | 25.260 |
1980 | 4 | 25.360 |
<colgroup><col span="3"></colgroup><tbody>
</tbody>
This continues till recently (2015).
Now, I would like to calculate the MIN value for each year over these 365 days, and put these in the following column, in order to have something like this:
1979 | 16.855 |
1980 | 16.139 |
<colgroup><col><col></colgroup><tbody>
</tbody>
I thought something like MIN(OFFSET(xxxx)) could do it. But I just couldn't figure out how...
Thanks for any hints how to achieve this.