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