I'm not really sure how to do this or even if there is a way it can be done (but I'm really hoping it can).
I need to find the days when a specific subject is taught. The subject name will always contain the characters 11a/En which will be followed by 1, 2, 3, 4 etc. At the moment my table looks something like this:
<tbody>
</tbody>
So basically I need a formula that will tell that an 11a/En class will be taught at AMon2 and AMon3 - is there any way this can be done?
Thanks
I need to find the days when a specific subject is taught. The subject name will always contain the characters 11a/En which will be followed by 1, 2, 3, 4 etc. At the moment my table looks something like this:
AMon1 | AMon2 | AMon3 | ATues1 | |
AJA | 11a/Ma1 | 7b/Sc1 | 11a/En1 | 8b/Pe1 |
HGE | 8c/Te1 | 11a/En2 | 8b/Re1 | 7a/En1 |
<tbody>
</tbody>
So basically I need a formula that will tell that an 11a/En class will be taught at AMon2 and AMon3 - is there any way this can be done?
Thanks