ineedhelp1
New Member
- Joined
- Apr 22, 2015
- Messages
- 15
Hi,
I have my data set out in the following format
<tbody>
</tbody>
I need to count the unique values based on a single date and then to count if it meets the criteria of NIGHT SHIFT only.
So the result I would expect for the 01/01/2015 would be 2 vehicle licence plates did a Night shift on this date.
I have achieved a full count of unique values by using the array formula:
However, I'm really struggling to get this to only count if it says the date and the NIGHT SHIFT criteria.
Is any one able to point me in the right direction?
Thanks in advance!
I have my data set out in the following format
01/01/2015 | licence plate 1 | DAY SHIFT |
01/01/2015 | licence plate 1 | NIGHT SHIFT |
01/01/2015 | licence plate 2 | NIGHT SHIFT |
01/01/2015 | licence plate 2 | DAY SHIFT |
02/01/2015 | licence plate 1 | NIGHT SHIFT |
<tbody>
</tbody>
I need to count the unique values based on a single date and then to count if it meets the criteria of NIGHT SHIFT only.
So the result I would expect for the 01/01/2015 would be 2 vehicle licence plates did a Night shift on this date.
I have achieved a full count of unique values by using the array formula:
{=SUM(IF(FREQUENCY(IF(LEN(O7:O12)>0,MATCH(O7:O12,O7:O12,0),""), IF(LEN(O7:O12)>0,MATCH(O7:O12,O7:O12,0),""))>0,1))}
However, I'm really struggling to get this to only count if it says the date and the NIGHT SHIFT criteria.
Is any one able to point me in the right direction?
Thanks in advance!