Week No | Match | Result |
1 | FALSE | |
1 | TRUE | YES |
1 | TRUE | |
2 | TRUE | YES |
2 | FALSE | |
2 | TRUE | |
2 | FALSE | |
3 | FALSE | |
3 | TRUE | YES |
4 | FALSE | |
4 | FALSE | |
4 | TRUE | YES |
5 | TRUE | YES |
5 | TRUE |
<tbody>
</tbody>
Hi, I am trying to find a way to get the third column in the above dataset to find the first TRUE value in each week (which I have manually done myself above).
Obviously I need a macro but no idea where to even begin with this, any help much appreciated.
Thanks