Hi,

I will try my best to explain this problem.

We have a running report. Weeks in columns...(Jan week 1, Jan week
2.......December week 4). In these columns we have names of people who
acheived 100% target in that particular week. Now we need 3 kinds of
information from this report.

1. Who acheived 100% in the week. This is done just by pasting names in the
column
2. Who is a consecutive acheiver (Last week and current week) This is done
by highlighting names which are also there in the previous column using
conditional formatting.
3. Anyone who acheives 100% for 5 consecutive weeks. This is the problem I
am talking about here. Currently what I have done is inserted one column
after every column and in front of every name I have entered this formula
=IF(COUNTIF(last_5_weeks_columns,name,"5 consecutive weeks acheived","")

Is there a better and easier way to do this?

Thanks
Gary