Excel attendance patterns

[mematedavev]

Hi,

I have attached an example of the attendance spreadsheet I am using. I want to create a formula that tells me how many days since the most recent specific attendance code. All present codes are marked as / but any unauthorised days are O, Medical is M, authorised is C etc. I want to create a formula that tells me how many days it has been since a O/C/M code.

 

[mematedavev]

I guess my question is about a formula to count back the cells to calculate how many days attendance since the last code that isn’t either / or \