Hi,

I have a question regarding counting cells where you don't know the values you need to count. If you look at the attached JPG, the data in the table A1:I7 is generated automatically. It shows projects that staff members are working on in the morning and afternoon in any given week.

ExcelCounts.jpg

My question is how can I get the unique project names to display in cells A11, A12, A13 etc? I don't know what the projects are before I get the data, so I need a formula that says get me the names of the unique projects in the range B3:I7 and then give me a count for each of these unique projects. The data I have shown in the JPG in cells A10:B16 is hard written to show what I am looking for.

Thanks in advance for any help.

Cheers,
Steve