Hello guys
I was wondering if anyone might be able to help me with the following problem. I have a table that has data by weeks. I want to create a reference that lists each week by month or even quarter and then perform statistical calculations (min, max, median, etc) to the data that meets the time period selected.
For example
<tbody>
</tbody>
I want to create a separate reference list that would look something like
<tbody>
</tbody>
In theory I would have a custom list where the user can select the desired time period (either a quarter, or a month) and then have the formula take that, look for the corresponding weeks and then perform a calculation. Say for example the median of July, or the sum of Q4
I know it has to be a nested formula, but not sure which operations and in what order to write it so it works.
Thank you
I was wondering if anyone might be able to help me with the following problem. I have a table that has data by weeks. I want to create a reference that lists each week by month or even quarter and then perform statistical calculations (min, max, median, etc) to the data that meets the time period selected.
For example
7/26 | 7/19 | 10/29 | 10/22 |
1 | 1 | 2 | 2 |
<tbody>
</tbody>
I want to create a separate reference list that would look something like
Q3 | 7/26 |
Q3 | 7/19 |
July | 7/26 |
July | 7/19 |
<tbody>
</tbody>
In theory I would have a custom list where the user can select the desired time period (either a quarter, or a month) and then have the formula take that, look for the corresponding weeks and then perform a calculation. Say for example the median of July, or the sum of Q4
I know it has to be a nested formula, but not sure which operations and in what order to write it so it works.
Thank you
Last edited: