Count Formula

[Wsheffield]

Hi there,

I'm trying to create a list of resources for a project management group at work. There is a great deal of overlap between the lists I'm getting, over several different projects. Does anyone have an idea of how I can create a formula which only counts the same person once, when pulling from several worksheets?

 

[aravindhan_31]

Try Pivot table or Advance filter with unique record option

 

[Armando Montes]

Try this:
=SUMPRODUCT(1/COUNTIF(A2:A7,A2:A7))