Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to count but exclude overlapping data
Hi,
I'm trying to count the number of mouse calls in a sound file and used another program to detect and count these calls, but to get all of the calls I had to use two different detectors on the file, which caused many of the calls to be counted twice, (once each by the two detectors). Now I want to use excel to exclude all of the calls that were counted twice and get a total count. I have information on the start and stop times for each call counted, but these are different depending on which detector is used, even for the same call. I was wondering if there is some way to get excel to count the calls, but only count the doubles once by excluding ones that overlap. Thanks! Example: Detector 1 Detector 2 Start Time End Time Start Time End Time 1 0.205 0.227 0.203 0.236 <- These are happening at 2 2.415 2.443 0.323 0.371 the same time 3 2.567 2.632 0.605 0.689 4 2.76 2.849 2.392 2.457 5 2.957 3.021 2.517 2.652 6 3.085 3.097 3.325 3.389 7 3.147 3.233 3.547 3.589 8 3.325 3.383 3.628 3.687 9 3.565 3.584 4.593 4.648 10 3.628 3.664 4.737 4.8 11 4.091 4.136 4.84 4.965 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count but exclude overlapping data
Hi,
Am Tue, 30 Apr 2013 21:17:26 +0100 schrieb amh3258: Example: Detector 1 Detector 2 Start Time End Time Start Time End Time 1 0.205 0.227 0.203 0.236 <- These are happening at 2 2.415 2.443 0.323 0.371 the same time 3 2.567 2.632 0.605 0.689 4 2.76 2.849 2.392 2.457 5 2.957 3.021 2.517 2.652 6 3.085 3.097 3.325 3.389 7 3.147 3.233 3.547 3.589 8 3.325 3.383 3.628 3.687 9 3.565 3.584 4.593 4.648 10 3.628 3.664 4.737 4.8 11 4.091 4.136 4.84 4.965 try: =COUNT(A1:A13)+SUMPRODUCT(--(ABS(1-C3:C13/A3:A13)1%)) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
sumproduct exclude count | Excel Worksheet Functions | |||
sumproduct exclude count | Excel Worksheet Functions | |||
sumproduct exclude count | Excel Worksheet Functions | |||
exclude data from count | Excel Worksheet Functions |