Data Sorting and Analysis-Conditional statement-Cell referencing?

DeepanshuS

New Member
Joined
Nov 22, 2017
Messages
2
Hi,

I have acquired two set of datasets with Time versus Data; T1 vs D1 and T2 vs D2
T1,T2 is timestamps in hh:mm:ss.00 and D1,D2 is data in Numbers format.
T1 and T2 intervals are different, while the T1 has ~1second interval, T2 has ~100 millisecond interval. However the overall time period is same.

I am looking for help to determine the cell (value) of say D2, which has corresponding T2 closest to T1.
In similar manner, I want to find the D1 value, which has corresponding T1 closest to a given T2 value.

I have mentioned closest as the time intervals are not regular an may have missed entries.
It might be easier to see the data which I have passed below and also attached the excel file.

Many thanks for help.

http://s000.tinyupload.com/?file_id=01336087424723571000[TABLE="width: 500"]
<tbody>[TR]
[TD]
[TABLE="width: 791"]
<tbody>[TR]
[TD]Time (hh:mm:ss.00)
[/TD]
[TD]Data1
[/TD]
[TD][/TD]
[TD]Time (hh:mm:ss.00)
[/TD]
[TD]Data2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]T1
[/TD]
[TD]D1
[/TD]
[TD]D2 (for T1 timestamps)
[/TD]
[TD]T2
[/TD]
[TD]D2
[/TD]
[TD]D1 (for T1 timestamps)
[/TD]
[/TR]
[TR]
[TD]14:25:41.93
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:43.84
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:42.95
[/TD]
[TD]32695.90843
[/TD]
[TD][/TD]
[TD]14:25:43.91
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:43.95
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:43.99
[/TD]
[TD]6496.393555
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:44.99
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:44.06
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:46.01
[/TD]
[TD]32695.90843
[/TD]
[TD][/TD]
[TD]14:25:44.14
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:47.01
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:44.21
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:48.05
[/TD]
[TD]32695.90843
[/TD]
[TD][/TD]
[TD]14:25:44.29
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:49.07
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:44.36
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:50.09
[/TD]
[TD]32695.90843
[/TD]
[TD][/TD]
[TD]14:25:44.44
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:51.08
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:44.51
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:52.13
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:44.58
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:53.15
[/TD]
[TD]32695.90843
[/TD]
[TD][/TD]
[TD]14:25:44.66
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:54.17
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:44.73
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:55.17
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:44.81
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:56.21
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:44.88
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:57.20
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:44.96
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:58.25
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:45.03
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:25:59.24
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:45.11
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:26:00.26
[/TD]
[TD]32695.90843
[/TD]
[TD][/TD]
[TD]14:25:45.18
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:26:01.31
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:45.25
[/TD]
[TD]6494.585938
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:26:02.30
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:45.33
[/TD]
[TD]6496.393555
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:26:03.35
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:45.40
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:26:04.37
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:45.48
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:26:05.36
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:45.55
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:26:06.41
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:45.63
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:26:07.43
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:45.70
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:26:08.45
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:45.78
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:26:09.44
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:45.85
[/TD]
[TD]6496.393555
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:26:10.46
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:45.93
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:26:11.51
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:46.00
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:26:12.53
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:46.07
[/TD]
[TD]6494.395996
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:10.80
[/TD]
[TD]32695.89953
[/TD]
[TD][/TD]
[TD]14:25:46.15
[/TD]
[TD]6496.583496
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:11.85
[/TD]
[TD]32695.90843
[/TD]
[TD][/TD]
[TD]14:25:46.22
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:12.84
[/TD]
[TD]32695.90843
[/TD]
[TD][/TD]
[TD]14:25:46.30
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:13.89
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:46.37
[/TD]
[TD]6496.583496
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:14.88
[/TD]
[TD]32695.90843
[/TD]
[TD][/TD]
[TD]14:25:46.45
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:15.90
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:46.52
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:16.95
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:46.60
[/TD]
[TD]6496.583496
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:17.94
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:46.67
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:18.96
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:46.74
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:20.01
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:46.82
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:21.00
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:46.89
[/TD]
[TD]6496.583496
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:22.04
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:46.97
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:23.06
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:47.04
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:24.08
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:47.12
[/TD]
[TD]6496.583496
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:25.08
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:47.19
[/TD]
[TD]6495.584961
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:26.12
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:47.26
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:27.12
[/TD]
[TD]32695.93516
[/TD]
[TD][/TD]
[TD]14:25:47.34
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:28.14
[/TD]
[TD]32695.91734
[/TD]
[TD][/TD]
[TD]14:25:47.41
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:29.16
[/TD]
[TD]32695.93516
[/TD]
[TD][/TD]
[TD]14:25:47.49
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:30.20
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:47.56
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:31.20
[/TD]
[TD]32695.93516
[/TD]
[TD][/TD]
[TD]14:25:47.64
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:32.24
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:47.71
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:33.26
[/TD]
[TD]32695.93516
[/TD]
[TD][/TD]
[TD]14:25:47.79
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:34.26
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:47.86
[/TD]
[TD]6496.583496
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:35.30
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:47.93
[/TD]
[TD]6496.393555
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:36.32
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:48.01
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:37.32
[/TD]
[TD]32695.93516
[/TD]
[TD][/TD]
[TD]14:25:48.08
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:38.36
[/TD]
[TD]32695.93516
[/TD]
[TD][/TD]
[TD]14:25:48.16
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:39.35
[/TD]
[TD]32695.92625
[/TD]
[TD][/TD]
[TD]14:25:48.23
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:28:40.37
[/TD]
[TD]32695.94407
[/TD]
[TD][/TD]
[TD]14:25:48.31
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:29:55.87
[/TD]
[TD]32695.86389
[/TD]
[TD][/TD]
[TD]14:25:48.38
[/TD]
[TD]6496.393555
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:29:56.86
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:48.46
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:29:57.91
[/TD]
[TD]32695.86389
[/TD]
[TD][/TD]
[TD]14:25:48.53
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:29:58.90
[/TD]
[TD]32695.85498
[/TD]
[TD][/TD]
[TD]14:25:48.61
[/TD]
[TD]6495.584961
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:29:59.92
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:48.68
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:00.97
[/TD]
[TD]32695.85498
[/TD]
[TD][/TD]
[TD]14:25:48.76
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:01.96
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:48.83
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:03.01
[/TD]
[TD]32695.86389
[/TD]
[TD][/TD]
[TD]14:25:48.90
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:04.00
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:48.98
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:05.05
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:49.05
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:06.07
[/TD]
[TD]32695.85498
[/TD]
[TD][/TD]
[TD]14:25:49.13
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:07.09
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:49.20
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:08.08
[/TD]
[TD]32695.85498
[/TD]
[TD][/TD]
[TD]14:25:49.28
[/TD]
[TD]6495.584961
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:09.10
[/TD]
[TD]32695.85498
[/TD]
[TD][/TD]
[TD]14:25:49.35
[/TD]
[TD]6496.583496
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:10.14
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:49.42
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:11.16
[/TD]
[TD]32695.85498
[/TD]
[TD][/TD]
[TD]14:25:49.50
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:12.18
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:49.57
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:13.18
[/TD]
[TD]32695.86389
[/TD]
[TD][/TD]
[TD]14:25:49.65
[/TD]
[TD]6496.393555
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:14.22
[/TD]
[TD]32695.85498
[/TD]
[TD][/TD]
[TD]14:25:49.72
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:15.25
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:49.80
[/TD]
[TD]6494.395996
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:16.24
[/TD]
[TD]32695.85498
[/TD]
[TD][/TD]
[TD]14:25:49.87
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:17.26
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:49.95
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:18.30
[/TD]
[TD]32695.85498
[/TD]
[TD][/TD]
[TD]14:25:50.02
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:19.30
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:50.10
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:20.34
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:50.17
[/TD]
[TD]6495.680176
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:21.34
[/TD]
[TD]32695.85498
[/TD]
[TD][/TD]
[TD]14:25:50.24
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:22.38
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:50.32
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:23.38
[/TD]
[TD]32695.86389
[/TD]
[TD][/TD]
[TD]14:25:50.39
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:30:24.42
[/TD]
[TD]32695.85498
[/TD]
[TD][/TD]
[TD]14:25:50.47
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:20.48
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:50.54
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:21.53
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:50.62
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:22.55
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:50.69
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:23.55
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:50.76
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:24.59
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:50.84
[/TD]
[TD]6496.583496
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:25.61
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:50.91
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:26.63
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:50.99
[/TD]
[TD]6494.585938
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:27.65
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:51.06
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:28.67
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:51.14
[/TD]
[TD]6494.585938
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:29.69
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:51.21
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:30.68
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:51.29
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:31.73
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:51.36
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:32.75
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:51.44
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:33.74
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:51.51
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:34.79
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:51.59
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:35.78
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:51.66
[/TD]
[TD]6496.393555
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:36.80
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:51.73
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:37.85
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:51.81
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:38.84
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:51.88
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:39.86
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:51.96
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:40.88
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:52.03
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:41.93
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:52.11
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:42.92
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:52.18
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:43.97
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:52.25
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:44.99
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:52.33
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:45.98
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:52.40
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:47.03
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:52.48
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:48.02
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:52.55
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:31:49.07
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:52.63
[/TD]
[TD]6494.585938
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:12.69
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:52.70
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:13.71
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:52.78
[/TD]
[TD]6495.584961
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:14.71
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:52.85
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:15.75
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:52.93
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:16.77
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:53.00
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:17.79
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:53.07
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:18.79
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:53.15
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:19.83
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:53.22
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:20.83
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:53.30
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:21.87
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:53.37
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:22.89
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:53.45
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:23.88
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:53.52
[/TD]
[TD]6495.584961
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:24.93
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:53.60
[/TD]
[TD]6495.584961
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:25.92
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:53.67
[/TD]
[TD]6494.395996
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:26.97
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:53.75
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:27.96
[/TD]
[TD]32695.84607
[/TD]
[TD][/TD]
[TD]14:25:53.82
[/TD]
[TD]6494.585938
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:29.01
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:53.89
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:30.00
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:53.97
[/TD]
[TD]6495.584961
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:31.05
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:54.04
[/TD]
[TD]6495.584961
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:32.05
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:54.12
[/TD]
[TD]6495.584961
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:33.09
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:54.19
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:34.08
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:54.26
[/TD]
[TD]6494.681152
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:35.13
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:54.34
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:36.12
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:54.42
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:37.17
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:54.49
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:38.16
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:54.56
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:39.18
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:54.64
[/TD]
[TD]6495.584961
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:40.23
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:54.71
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:41.25
[/TD]
[TD]32695.81044
[/TD]
[TD][/TD]
[TD]14:25:54.79
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:42.24
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:54.86
[/TD]
[TD]6494.395996
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:33:43.29
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:54.94
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:40.40
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:55.01
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:41.42
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:55.09
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:42.41
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:55.16
[/TD]
[TD]6495.584961
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:43.46
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:55.24
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:44.48
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:55.31
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:45.47
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:55.38
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:46.49
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:55.46
[/TD]
[TD]6495.584961
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:47.51
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:55.53
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:48.53
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:55.61
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:49.58
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:55.68
[/TD]
[TD]6494.395996
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:50.57
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:55.75
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:51.61
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:55.83
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:52.64
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:55.90
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:53.63
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:55.98
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:54.65
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:56.05
[/TD]
[TD]6495.584961
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:55.69
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:56.13
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:56.69
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:56.20
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:57.73
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:56.28
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:58.73
[/TD]
[TD]32695.83717
[/TD]
[TD][/TD]
[TD]14:25:56.35
[/TD]
[TD]6495.584961
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:34:59.77
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:56.43
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:35:00.80
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:56.50
[/TD]
[TD]6496.489258
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:35:01.79
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:56.58
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:35:02.81
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:56.65
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:35:03.85
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:56.73
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:35:04.85
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:56.80
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:35:05.87
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:56.87
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:35:06.91
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:56.95
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:35:07.91
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:57.02
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:11.16
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:57.10
[/TD]
[TD]6494.585938
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:12.15
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:57.17
[/TD]
[TD]6494.585938
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:13.20
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:57.25
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:14.22
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:57.32
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:15.24
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:57.39
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:16.23
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:57.47
[/TD]
[TD]6494.395996
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:17.25
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:57.54
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:18.27
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:57.62
[/TD]
[TD]6493.492676
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:19.32
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:57.69
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:20.34
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:57.77
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:21.33
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:57.84
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:22.38
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:57.92
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:23.40
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:57.99
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:24.39
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:58.07
[/TD]
[TD]6496.393555
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:25.41
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:58.14
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:26.46
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:58.21
[/TD]
[TD]6495.39502
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:27.48
[/TD]
[TD]32695.81044
[/TD]
[TD][/TD]
[TD]14:25:58.29
[/TD]
[TD]6494.395996
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:28.47
[/TD]
[TD]32695.82826
[/TD]
[TD][/TD]
[TD]14:25:58.36
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:29.51
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:58.44
[/TD]
[TD]6495.490234
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14:36:30.53
[/TD]
[TD]32695.81935
[/TD]
[TD][/TD]
[TD]14:25:58.51
[/TD]
[TD]6494.491699
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Forum statistics

Threads
1,223,893
Messages
6,175,242
Members
452,623
Latest member
russelllowellpercy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top