Count Events within Time Interval

[bobbychoi]

Hi All,

I have a question about counting events between time intervals. For example:


Time (sec) Events
1.232
1.432
1.675
1.898 4
2.343
2.675
2.898 3
3.310
3.456
3.667
3.889
3.991
3.999 6

I was wondering if there was an excel function for this...

Thanks a bunch

 

[Marcelo Branco]

Assuming your data in columns A B (headers in row 1) maybe...

Formula in B2 copied down
=IF(INT(A2)<>INT(A3),SUMPRODUCT(--(INT(A$2:A2)=INT(A2))),"")

M.