Hi,

I have a excel data set with 7000 rows and about 10 columns.

Example: Columns a

€˜Login Id; €˜Int Vs Ext; €˜TA; €˜Protocol; €˜Site #

Under all these heading of columns are multiple records:

Example: If there are 20 unique login ids each appears multiple times. So is
the case with Int Vs Ext, TA, Protocol, Site #

I am trying to find:
1. Average number of €˜protocols per €˜login id
2. Average no of €˜sites # per €˜login id

I have been trying to do this using a pivot table and I get a count of all
the protocols that correspond to a Login Id. This is a reflection of how many
times a protocol appears in the data set. But I multiple entries of the same
protocol to be counted as one. This way if a login Id had for example 100
protocol entries, I wish to get how many of those 100 protocol entries are
unique. Example: if XXX appears 20 times, YYY appears 30 times, ZZZ appears
50 times in protocol records I need it to be counted XXX, YYY, ZZZ each once
making it a unique count of 3.

I would really appreciate your insights on this matter.

Rum