count unique values

[van gysel]

I have a serie of projects on which work experts
each project have 1 to infinite number of experts, a expert can work on several projects
I need to make a report with the number of experts per project
I found a solution that needs that the data are sorted on the project code
is it possible to find a more general formula?
see my file for more info

 

[Somendra Misra]

Hi Van,

See the file.

Regards,

 

[van gysel]

Thanks Misra

 

[Somendra Misra]

You are Welcome.

Regards,

 

[jeffreyweir]

Here's a couple more options, using PivotTables

 

[Somendra Misra]

@jeffreyweir

You won't believe my first attempt to this problem was PT. Than i got stuck in the first PT that you made and went back to formula

Regards,

 

[jeffreyweir]

Ha! Yeah, I stumbled on this one too at first!

 

[Syedali]

pfa