Find number of unique entries within a date range
 

I had not heard anything on my posting so I thought I would repost to see if
anyone had any suggestions for me.

I have a report that obtains its data from a worksheet that new data is
added to every week through copy/paste from our internal timecard system.
The data is made up of employee names, dates they clocked time, the amount
of time, the project and task they clocked time to.
My Data! Sheet Columns include:
A - Employee
B - Date
C - Hours
D - Project
I - Task

On my report I have a formula that tells me how many resources (employees)
are working on a particular project and task without counting the same person
twice.
The formula is:
COUNTDIFF(IF(Data!$D$2:$D$3286=$A$3,IF(Data!$I$2:$ I$3286=$A11,
Data!$A$2:$A$3286)),,FALSE)
A3 on report = project name from column D on Data! Sheet
A11 on report = task name from column I on Data! Sheet
Now I need to take it a step further. I want to know of those resources how
many have clocked time within the last 7 days from today. I tried starting
the previous formula with this: IF((Data!$B$2:$B$3286$A$1-7)
A1 on report = Todays Date
The answer I am getting is FALSE. Which may be true, there may not be
anyone who has clocked time on that task within the last week but instead of
FALSE I want a number - "0". If resources have clocked time I want the
number of employees minus any duplicates.
Any help will be appreciated.

Find number of unique entries within a date range
 

The problem is that COUNTDIFF is not a native Excel function. It's a custom
UDF or a function from a 3rd party add-in. So, the only people that know
what you're talking about are those that have the COUNTDIFF available to
them which greatly reduces your chances of getting a knowledgeable reply.

Biff

"Gayla" wrote in message
...
I had not heard anything on my posting so I thought I would repost to see
if
anyone had any suggestions for me.

I have a report that obtains its data from a worksheet that new data is
added to every week through copy/paste from our internal timecard system.
The data is made up of employee names, dates they clocked time, the amount
of time, the project and task they clocked time to.
My Data! Sheet Columns include:
A - Employee
B - Date
C - Hours
D - Project
I - Task

On my report I have a formula that tells me how many resources (employees)
are working on a particular project and task without counting the same
person
twice.
The formula is:
COUNTDIFF(IF(Data!$D$2:$D$3286=$A$3,IF(Data!$I$2:$ I$3286=$A11,
Data!$A$2:$A$3286)),,FALSE)
A3 on report = project name from column D on Data! Sheet
A11 on report = task name from column I on Data! Sheet
Now I need to take it a step further. I want to know of those resources
how
many have clocked time within the last 7 days from today. I tried
starting
the previous formula with this: IF((Data!$B$2:$B$3286$A$1-7)
A1 on report = Todays Date
The answer I am getting is FALSE. Which may be true, there may not be
anyone who has clocked time on that task within the last week but instead
of
FALSE I want a number - "0". If resources have clocked time I want the
number of employees minus any duplicates.
Any help will be appreciated.

Find number of unique entries within a date range
 

It's part of Laurent Longre's Morefunc add-in - but I've not yet used it so
can't be of much help.

http://xcell05.free.fr/english/

"T. Valko" wrote:

The problem is that COUNTDIFF is not a native Excel function. It's a custom
UDF or a function from a 3rd party add-in. So, the only people that know
what you're talking about are those that have the COUNTDIFF available to
them which greatly reduces your chances of getting a knowledgeable reply.

Biff

"Gayla" wrote in message
...
I had not heard anything on my posting so I thought I would repost to see
if
anyone had any suggestions for me.

I have a report that obtains its data from a worksheet that new data is
added to every week through copy/paste from our internal timecard system.
The data is made up of employee names, dates they clocked time, the amount
of time, the project and task they clocked time to.
My Data! Sheet Columns include:
A - Employee
B - Date
C - Hours
D - Project
I - Task

On my report I have a formula that tells me how many resources (employees)
are working on a particular project and task without counting the same
person
twice.
The formula is:
COUNTDIFF(IF(Data!$D$2:$D$3286=$A$3,IF(Data!$I$2:$ I$3286=$A11,
Data!$A$2:$A$3286)),,FALSE)
A3 on report = project name from column D on Data! Sheet
A11 on report = task name from column I on Data! Sheet
Now I need to take it a step further. I want to know of those resources
how
many have clocked time within the last 7 days from today. I tried
starting
the previous formula with this: IF((Data!$B$2:$B$3286$A$1-7)
A1 on report = Todays Date
The answer I am getting is FALSE. Which may be true, there may not be
anyone who has clocked time on that task within the last week but instead
of
FALSE I want a number - "0". If resources have clocked time I want the
number of employees minus any duplicates.
Any help will be appreciated.