![]() |
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