Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting unique values in a row | New Users to Excel | |||
Counting Unique | Excel Worksheet Functions | |||
Counting Unique Entries | Excel Discussion (Misc queries) | |||
Unique counting | Excel Discussion (Misc queries) | |||
Counting unique entries | Excel Discussion (Misc queries) |