Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index


Thank-you for the time and response

On 08/05/2017 08:54, Michael D. Setzer II wrote:
Not sure if I fully understand what you are looking at,
but here is what I have attempted.
Assuming you column data is:
A is month
B is day of Month
C is the rain on day in 2016
D is the rain on day in 2017

Correct :)

I've added Column E and Column F to be real date value.
E2 =DATE(2016,MATCH(A2,$G$1:$G$12),B2)
F2 =DATE(2017,MATCH(A2,$G$1:$G$12),B2)

This turns out to be a problem as I am working with five(5) years of data and whilst my example did not shot it there are multiple values under each month, even if it is zero.

I don't think five columns of dates is a smart way to do this.
I am rather going to investigate making my date column a rolling year numeric month/day for 365 rows, with the columns being divided into years.


Date    2016    2017    2018
0101    0       1       5
0102    1       0       0
0103    0       5       10
0501    1       0       0
0922    5       1       1
3112    0       1       0

I then reckon use of MATCH, DAYS, COUNTIF and SUM should deliver what I seek.

Your thoughts on how to get the rows in a column formatted as Date to show a sequential month and day number?

I have Bcc'd you as the message contain an attachment of my existing sheet.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.