Pivot Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Ello

I have a list like below

Ref Client Name Team TeamMat
1 John 1 Ia
2 Steve 1 Ima
3 Andres 2 Jiv
4 Micel 1 Ima
5 Miquel 2 Jiv

I wante to create pivot table to count the unique number of people in team, above team 1 has 2, team 2 has 1
Cant seem to do it with pivot table, is there way or create different type of table useing formulae

Thanks for hel

Tibow
 
Hi Tibow

based on a solution Harlan Grove posted (see http://tinyurl.com/33zxx)
use the following array function (to be entered with CTRL+SHIFT+ENTER):
=SUMPRODUCT(1/MMULT(--(IF(C1:C999=1,D1:D999)=TRANSPOSE(IF(C1:C999=1,D1:
D999))),ROW(D1:D999)^0))-1
This will return the unique entries for team 1.


HTH
Frank
 
Back
Top