| 2012/6/1 | 9:25:01 | 15.24 |
| 2012/6/1 | 9:30:04 | 15.26 |
| 2012/6/1 | 9:30:07 | 15.2 |
| 2012/6/1 | 9:30:22 | 15.2 |
| 2012/6/1 | 9:30:31 | 15.2 |
| 2012/6/1 | 9:30:43 | 15.28 |
| 2012/6/1 | 9:30:58 | 15.28 |
| 2012/6/1 | 10:00:13 | 15.13 |
| 2012/6/1 | 10:00:16 | 15.15 |
| 2012/6/1 | 10:00:22 | 15.12 |
| 2012/6/1 | 10:00:28 | 15.12 |
| 2012/6/1 | 10:00:40 | 15.13 |
| 2012/6/1 | 10:00:43 | 15.18 |
| 2012/6/1 | 10:30:19 | 15.18 |
| 2012/6/1 | 10:30:37 | 15.19 |
| 2012/6/1 | 10:30:46 | 15.19 |
| 2012/6/1 | 11:00:13 | 15.24 |
| 2012/6/1 | 11:00:28 | 15.24 |
| 2012/6/1 | 11:00:55 | 15.24 |
| 2012/6/1 | 11:29:11 | 15.21 |
| 2012/6/1 | 11:29:20 | 15.21 |
| 2012/6/1 | 11:29:35 | 15.22 |
| 2012/6/1 | 11:29:44 | 15.21 |
| 2012/6/1 | 11:29:59 | 15.2 |
| 2012/6/1 | 13:00:03 | 15.19 |
| 2012/6/1 | 13:00:09 | 15.22 |
| 2012/6/1 | 13:00:39 | 15.2 |
| 2012/6/1 | 13:30:03 | 15.18 |
| 2012/6/1 | 13:30:24 | 15.18 |
| 2012/6/1 | 13:30:30 | 15.18 |
| 2012/6/1 | 13:30:33 | 15.18 |
| 2012/6/1 | 14:00:01 | 15.12 |
| 2012/6/1 | 14:00:28 | 15.09 |
| 2012/6/1 | 14:30:31 | 15.04 |
| 2012/6/1 | 14:30:52 | 15.05 |
| 2012/6/1 | 15:00:25 | 15.07 |
| 2012/6/4 | 9:30:04 | 14.74 |
| 2012/6/4 | 9:30:16 | 14.74 |
| 2012/6/4 | 9:30:22 | 14.74 |
| 2012/6/4 | 9:30:28 | 14.79 |
| 2012/6/4 | 9:30:40 | 14.8 |
| 2012/6/4 | 9:30:52 | 14.8 |
| 2012/6/4 | 10:00:14 | 14.87 |
| 2012/6/4 | 10:00:35 | 14.86 |
| 2012/6/4 | 10:00:59 | 14.86 |
| 2012/6/4 | 10:30:11 | 14.82 |
| 2012/6/4 | 10:30:23 | 14.81 |
| 2012/6/4 | 10:30:29 | 14.82 |
| 2012/6/4 | 10:30:35 | 14.81 |
| 2012/6/4 | 10:30:50 | 14.82 |
| 2012/6/4 | 11:00:02 | 14.83 |
| 2012/6/4 | 11:00:44 | 14.83 |
| 2012/6/4 | 11:00:53 | 14.82 |
| 2012/6/4 | 11:29:11 | 14.66 |
| 2012/6/4 | 11:29:20 | 14.67 |
| 2012/6/4 | 11:29:29 | 14.66 |
| 2012/6/4 | 11:29:38 | 14.66 |
| 2012/6/4 | 13:00:01 | 14.66 |
| 2012/6/4 | 13:00:04 | 14.66 |
| 2012/6/4 | 13:00:07 | 14.64 |
| 2012/6/4 | 13:00:28 | 14.64 |
| 2012/6/4 | 13:00:55 | 14.62 |
| 2012/6/4 | 13:30:22 | 14.68 |
| 2012/6/4 | 13:30:25 | 14.68 |
| 2012/6/4 | 13:30:28 | 14.69 |
| 2012/6/4 | 13:30:34 | 14.68 |
| 2012/6/4 | 14:00:02 | 14.72 |
| 2012/6/4 | 14:00:35 | 14.71 |
| 2012/6/4 | 14:30:05 | 14.7 |
| 2012/6/4 | 14:30:23 | 14.69 |
| 2012/6/4 | 14:30:26 | 14.64 |
| 2012/6/4 | 14:30:35 | 14.69 |
| 2012/6/4 | 14:30:41 | 14.68 |
| 2012/6/4 | 14:30:44 | 14.64 |
| 2012/6/4 | 15:00:23 | 14.52 |
| 2012/6/5 | 9:30:05 | 14.59 |
| 2012/6/5 | 9:30:20 | 14.6 |
| 2012/6/5 | 9:30:47 | 14.64 |
| 2012/6/5 | 9:30:59 | 14.64 |
| 2012/6/5 | 10:00:00 | 14.5 |
| 2012/6/5 | 10:00:06 | 14.5 |
| 2012/6/5 | 10:00:57 | 14.49 |
| 2012/6/5 | 10:30:09 | 14.7 |
| 2012/6/5 | 10:30:15 | 14.7 |
| 2012/6/5 | 10:30:24 | 14.7 |
| 2012/6/5 | 10:30:30 | 14.69 |
| 2012/6/5 | 10:30:57 | 14.69 |
| 2012/6/5 | 11:00:18 | 14.57 |
| 2012/6/5 | 11:00:51 | 14.55 |
| 2012/6/5 | 11:29:31 | 14.55 |
| 2012/6/5 | 11:29:52 | 14.55 |
| 2012/6/5 | 13:00:08 | 14.61 |
| 2012/6/5 | 13:00:11 | 14.52 |
| 2012/6/5 | 13:30:03 | 14.61 |
| 2012/6/5 | 13:30:06 | 14.6 |
| 2012/6/5 | 13:30:30 | 14.62 |
| 2012/6/5 | 13:30:36 | 14.6 |
| 2012/6/5 | 13:30:42 | 14.62 |
| 2012/6/5 | 14:00:12 | 14.63 |
| 2012/6/5 | 14:00:39 | 14.63 |
| 2012/6/5 | 14:30:03 | 14.55 |
| 2012/6/5 | 15:00:25 | 14.45 |
| 2012/6/6 | 9:30:04 | 14.43 |
| 2012/6/6 | 9:30:49 | 14.5 |
| 2012/6/6 | 9:30:52 | 14.5 |
| 2012/6/6 | 10:00:17 | 14.53
|
如上面的数据,高频数据预先处理一下,需要筛选出相同日期相同分钟的最大秒数的那一个结果,EXCEL中,求问应该如何编写语句 ,最后保留秒数最大的那一行所有数据, 谢谢