Forum Discussion
Counting Bradford score number of occasions?
Hi, Please help. We currently use an Excel spreadsheet to record holiday, sickness and absence for my staff and we use the Bradford score system to monitor attendance. (Please see attachment...
Hi James,
By doing simple macro, we can make it possible. Doing it.
Hi James Diaper
Paste this macro. Hope it will work. 98%.
Sub Occa()
For r = 7 To 10
ct = 0
For i = 2 To 11
Cells(r, i).Select
a = Cells(r, i).Value
b = Cells(r, i + 1).Value
c = Cells(r, i - 1).Value
If a = "S" And b = "" Then
ct = ct + 1
End If
Next i
Cells(r, 19).Value = ct
Next r
End Sub
