View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KR KR is offline
external usenet poster
 
Posts: 24
Default 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?