The required results from the below data are: Required Result Week 25 = Batches 25 Week 26 = Batches 40 Data
<colgroup><col><col><col></colgroup><tbody> </tbody> |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
The required results from the below data are: Required Result Week 25 = Batches 25 Week 26 = Batches 40 Data
<colgroup><col><col><col></colgroup><tbody> </tbody> |
I think you should be thanking Weazel, not me.Amazing and perfect.
Exactly what I wanted, saved me so much time.
Thank you so much for your time and help, Rick.
Much appreciated.
Date | Value | |
16/06/14 | 5 6 6 | |
17/06/14 | 6 1 3 | |
18/06/14 | 9 2 3 | |
19/06/14 | 2 3 5 | |
20/06/14 | 3 3 4 | |
Questions...Thank you so much for the previous answer, it's been very helpful.
Another similar question please.
How do we sum up the values for each date, e.g. from the data below, how do we get result of 16/06/14 = 17, 17/06/14 = 10 and so on...
Date Value 16/06/14
5
6
617/06/14 6
1
3
18/06/14 9
2
3
19/06/14 2
3
5
20/06/14 3
3
4
<tbody>
</tbody>
All values are in next row and there could be 1-10 rows under each date. I tried to upload the file or image but do not know how to do that...
So, it will be like:
A2= 16/06/14 C2 = 5
C3 = 6
C4 = 6
<tbody>
</tbody>