Looking to summarise a table in Excel 2007
Category, count of accesses, count of unique people accessing
There doesn't appear to be a function for count of unique entries
Googling produced add a new column in the data =IF(COUNTIF($A$1:A1,A1)=1,1,0)
and then sum that
But over many thousands of rows it grinds to a halt
An alternative grouping here by two columns is createing a column
isFirstAccess with formula =IF(AND(A7=A6,D7=D6),0,1)
after sorting by A and D
Then summing that in the pivot table, which works fine.
No comments:
Post a Comment