Hi,

I have the following problem:

I have a workbook with several employees. These employees have worked on different porjects during the year. Now I want to count the number of projects they worked at at the same time. So I want to take every unique employee number and count the number of projects they worked at simultaniously.

It kind off looks like this:

parallel periods.PNG

I have excel 2010 (and 2007) and tried to work something out with powerpivot. But failed. Is there an easy way to do this?

Thank you!