So, as per sheet 2 of the attached is a count of items, is that how you
would see your data?
using
=COUNTIF(Test1!C2:C409,D2)
--
A S-D Wrote:
Again, thanks for looking at this problem. I wish I could explain this
more simply!
Bryan, the column C is merely the whole testing period split into 15
minute intervals. It is what I want my data ordered by:
Cumulative
Time 15 minute
intervals Voltage of turn.
0:00:00 00:00:00 -0.06
0:18:44 00:15:00 5.02
0:18:45 00:30:00 -0.02
1:16:59 00:45:00 2.52
1:17:00 01:00:00 -0.04
Should become:
Code:
--------------------
15 Minute Intervals // Cumulative Time // Voltage of Turn (rest of data)
00:00:00 0:00:00 -0.06
00:15:00 0:18:44 5.02
[EMPTY] 0:18:45 -0.02
00:30:00 [EMPTY] 0
00:45:00 [EMPTY] 0
01:00:00 [EMPTY] 0
01:15:00 1:16:59 2.52
[EMPTY] 1:17:00 -0.04
--------------------
Does that help?
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=530452