Ok, next problem I had at work and I did it manually but would by interested how to do it automatically. In rows we have countries and lets say values for dates in columnes measure happiness of people in those countries. Empty cells mean people are unhappy.
So we have periods of hapiness like for example For USA from 1.1.2014-2.3.2014 and from 6.7.2014-10.10.2014. We recognize these because all cells in these periods have values.
What I want to accomplish is to extract all starts and end of periods (they might be one two.....) into a table below for all countries. So whenever blanks occur a period is finished and so on.
In particular it would suit me more to have like 5 days containing blanks not be interrupting a period so it would would still be considered the same period if 5 and less blanks occur consecutively. but it would be probably quite harder thing to do.
thanks
So we have periods of hapiness like for example For USA from 1.1.2014-2.3.2014 and from 6.7.2014-10.10.2014. We recognize these because all cells in these periods have values.
What I want to accomplish is to extract all starts and end of periods (they might be one two.....) into a table below for all countries. So whenever blanks occur a period is finished and so on.
In particular it would suit me more to have like 5 days containing blanks not be interrupting a period so it would would still be considered the same period if 5 and less blanks occur consecutively. but it would be probably quite harder thing to do.
thanks
