Hi everyone!

Before I start I want you to know that I posted this "problem" already in an german excel forum. So please dont get mad at me because of "cross-posting" etc.


Iam currently an intern at a big company, where they gave me the following task:

We have a huge excel-sheet, containing disputes with customers. Everytime there is a dispute, the customers data will be transferred into the sheet. The sheet is organized like this:

DATE / NAME / ID / COMMENT / FREQUENCY (how often one customer appears in the list) /ID2 (ID combination of the date + ID) /Weekday

And here comes the task:

Find all customers who appear 10 work-days(Mo-Fr) in a row. So if a customer appears Mo-Fr and keeps on being in the list the next Monday etc. it still counts as "in a row". Same with official holidays. If a customer appears at a certain date he is "booked" and it doesnt matter if a appears a second time on that specific date.

Attached to this post you find an example in which you can see the structure of my excel sheet!
example.xls

Note: I had to use a german version of excel when I made this little example - thats why the formula in the collum "Frequency" says "Zählenwenn" its the german version of COUNTIF

At work I use an english version of Excel 2003

It would be great if someone had an ideo how to solve this! Right now I dont

Thanks!!