Hia,
I am looking for a formula that will count the number of adjacent cells that meet a specific condition starting from Column A & looking for the word Required.
In the example below ......
Row 1 should return 2
Row 2 should return 1
Row 3 should return 2
Row 4 should return 3
Row 5 should return 0
Row 6 should return 0
<tbody>
</tbody>
Hope the above makes sense - have been bashing my head on this one for hours now so hoping someone can point me in the right direction.
Many thanks !!
I am looking for a formula that will count the number of adjacent cells that meet a specific condition starting from Column A & looking for the word Required.
In the example below ......
Row 1 should return 2
Row 2 should return 1
Row 3 should return 2
Row 4 should return 3
Row 5 should return 0
Row 6 should return 0
Required | Required | N#A |
Required | Match (12-JUN-18) | Required |
Required | Required | |
Required | Required | Required |
Not Required | Required | Required |
Match (12-JUN-18) | Required | Match (12-JUN-18) |
<tbody>
</tbody>
Hope the above makes sense - have been bashing my head on this one for hours now so hoping someone can point me in the right direction.
Many thanks !!