ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   counting and unique (https://www.excelbanter.com/excel-discussion-misc-queries/218276-counting-unique.html)

KR

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?


All times are GMT +1. The time now is 06:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com