Unique Records Help

[pivot table]

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?

 

[Pete_UK]

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

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)

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

 

[Sheeloo]

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.