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

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