Forum Discussion
James Diaper
Apr 29, 2018Copper Contributor
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...
Logaraj Sekar
Apr 30, 2018Steel Contributor
Hi James,
By doing simple macro, we can make it possible. Doing it.
- Logaraj SekarMay 02, 2018Steel Contributor
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