#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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting unique values in a row BASCRUMMY New Users to Excel 8 August 12th 08 06:29 PM
Counting Unique tonyalt3 Excel Worksheet Functions 1 April 16th 08 11:32 PM
Counting Unique Entries Tendresse Excel Discussion (Misc queries) 3 June 4th 07 08:19 AM
Unique counting Michael Excel Discussion (Misc queries) 19 November 27th 06 09:28 AM
Counting unique entries DianeandChipps Excel Discussion (Misc queries) 1 October 14th 06 07:35 PM


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"