I need report Unique Users on a daily basis then have a monthly Unique Users
Total.


When I add the daily Unique Users, it should add up to be the same as the
Monthly Unique Users total...

How do you I do that to get the true daily and monthly Unique Users?

You can obtain unique records using Advanced Filter - Debra Dalgleish
shows how he

http://www.contextures.com/xladvfilter01.html#FilterUR

Once you have your list of unique users, you can use SUMIF to obtain a
total for each user. For example, suppose your unique list is in
column A of Sheet 2, and on Sheet1 you have a list of users also in
column A with something to be totalled in column D, then this formula
in B2 of Sheet2:

=SUMIF(Sheet1!A:A,A2,Sheet1!D:D)

will give you the total from Sheet1 for the user in A2. Just copy this
down to get the totals for other users.

Hope this helps.

Pete

On Aug 21, 11:11*pm, pivot table
wrote:
I need report Unique Users on a daily basis then have a monthly Unique Users
Total. *

When I add the daily Unique Users, it should add up to be the same as the
Monthly Unique Users total...

How do you I do that to get the true daily and monthly Unique Users?

If you add up 'Daily uniqe users', it will NOT add upto Monthly Unique users.
If I visit on more than one day, I will be on two daily totals whereas in the
month I should only be counted once.

"pivot table" wrote:

I need report Unique Users on a daily basis then have a monthly Unique Users
Total.


When I add the daily Unique Users, it should add up to be the same as the
Monthly Unique Users total...

How do you I do that to get the true daily and monthly Unique Users?