excel question?
=AVERAGE(IF($C$2:$C$33=0,$B$2:$B$33))
=MAX(IF($C$2:$C$33=0,$A$2:$A$33))
=MIN(IF($C$2:$C$33=0,$A$2:$A$33))
all array formulae
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"Mark J" wrote in message
...
already figured out first part without pivot table using;
=SUMIF(C2:C260,0,B2:B260)
but how do i find max/min time using this function:
=INDEX($A$2:$A$260,MATCH(0,MAX($C$2:$G$260,FALSE), 1))
DateTime FIQR_5350 rank
00:29:10 113.87 0
00:29:30 292.01 0
00:29:50 471.49 0
00:30:10 483.40 0
00:30:30 489.60 0
00:30:50 494.05 0
00:31:10 492.85 0
00:31:30 485.10 0
00:31:50 491.25 0
00:32:10 476.25 0
00:32:30 487.05 0
00:32:50 330.02 0
00:33:10 314.76 0
00:33:30 320.66 0
00:33:50 325.97 0
00:34:10 319.81 0
00:34:30 327.27 0
00:34:50 333.22 0
00:35:10 326.12 0
00:35:30 500.05 0
00:36:30 499.85 0
00:36:50 142.63 0
|