counting and unique
i have a table of information. as follows
Call Time Call Frm Call To Talk Time
12:01 Joe Me 0
12:06 Jed Me 56
3:05 Anna You 12
5:55 Ted Them 25
10:11 Joe Us 55
From there, I'm making the following columns.
Total Calls by hour: I use the sumproduct for this
Total Unique Calls: The excel forum guys helped me with this
But, what if I want to say, give me the unique times for call from by hour
that does not have a "0" talk time. What i want to say in expression is
"count only the first time the record shows up in the report and include in
the time"
Make sense?
|