Thread: checking for consecutive values

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

thenx for the quick reply
but i actually want to chek if the absence heppend 3 times in a row

i will try to expline better.
i would upload the file but i can't, and its in another langue so you problaly wont understand the file anyway
ether way
i have a list of meeting.
in that list
i have companies and in each company there is a number of people(i have the same people in sevrel companies).
an a date of the meeting and if that person was absence or not.
i need to flag to myself(for reports later on) for each person in a company that have more then 3 consecutive absences in a quarter.
if the absences is 3 but not consecutive i don't care.

do i make myself any more reasonable? :/

ok your right

in the file i upload i want to flag
that for person 1
he have 3 consecutive absence in a row...
but if i had another date in between(like the 3/9 ) with 0 instead of 1. then it won't flag me..

make any sense?

nop.... only 3 in a row....

i guess it's more difficult then i thought so

ohhh i'm sorry zbor, i didn't read it correctly... your were right.. it wont mark it

wow thats great
but i have few questions..
why do i get #num! in some fields?
and what does the formula does ? run the entire range and look for a series of 3 1's in a row? for the same person?
You're a genius, i can't thank you enough

and one more thing
can i get it to run for each quarter speardly?
for example if i had a lot more names in the list and much more dates
so that the run will go on each quarter and a year?