Hello everyone
I have a table that consists of date, name, company name, an absence.
in the absence filed there is numbers 0 and 1(for absence).
I would like to see who has an absence of more than 3 consecutive meetings.
Can anyone help me how to do it? Whether by the date whether by absence?
Excel formula or VBA.
I'm going crazy, so I would appreciate anyone who could only help

Thanks in advance
Raz