Hi all
I have some data in the following layout:
<tbody>
</tbody>
I need a formula which will will give me the total number of unique regions which have atleast 1 snow day between 2 seperately defined dates.
So say i define the dates as: 01/02/17 - 07/02/17 - the result should be 1, 08/02/17 - 14/02/17 the result would be 2.
That is to say in the first date range, Scotland had atleast 1 snow day, but wales had 0.
In the second date range both wales and scotland had 1 snowday, so the result would be 2.
Its the unique region bit that i'm stuck at.
I have some data in the following layout:
Date | Region | Snow |
01/02/17 | Scotland | 1 |
02/02/17 | Scotland | 1 |
03/02/17 | Scotland | 0 |
08/02/17 | Scotland | 1 |
02/02/17 | Wales | 0 |
08/02/17 | Wales | 1 |
<tbody>
</tbody>
I need a formula which will will give me the total number of unique regions which have atleast 1 snow day between 2 seperately defined dates.
So say i define the dates as: 01/02/17 - 07/02/17 - the result should be 1, 08/02/17 - 14/02/17 the result would be 2.
That is to say in the first date range, Scotland had atleast 1 snow day, but wales had 0.
In the second date range both wales and scotland had 1 snowday, so the result would be 2.
Its the unique region bit that i'm stuck at.