Spreadsheet: 466271d1466092182-extract-unique-points-from-table-column-and-sort-by-smallest-to-largest-for-indexmatch-use-pivot-table-to-get-unique-row
Sheet: Sheet1

RowNum | SampleDateTime | AnalysisValue |  |  |  | Row Labels | Sum of AnalysisValue
10 | 2016-04-11 07:35:00 | 1 |  |  |  | 2010 | 28.5757575757576
9 | 2016-04-18 09:35:00 | 2 |  |  |  | 2012 | 28.8181818181818
8 | 2016-04-25 08:20:00 | 3 |  |  |  | 2016
7 | 2016-05-02 08:45:00 | 4 |  |  |  | Qtr1
6 | 2016-05-09 03:20:00 | 5 |  |  |  | Mar | 18.6060606060606
5 | 2016-05-16 09:55:00 | 1 |  |  |  | 9.18181818181818 | 9.18181818181818
4 | 2016-05-23 07:45:00 | 2 |  |  |  | 9.42424242424242 | 9.42424242424242
3 | 2016-05-30 09:55:00 | 3 |  |  |  | Qtr2
2 | 2016-06-06 07:20:00 | 4 |  |  |  | Apr | 60.30303030303031
1 | 2016-06-13 08:30:00 | 5 |  |  |  | 1 | 1
10 | 2016-04-11 07:35:00 | 4.33333333333333 |  |  |  | 2 | 2
9 | 2016-04-18 09:35:00 | 4.57575757575758 |  |  |  | 3 | 3
8 | 2016-04-25 08:20:00 | 4.81818181818182 |  |  |  | 4.33333333333333 | 4.33333333333333
7 | 2016-05-02 08:45:00 | 5.06060606060606 |  |  |  | 4.57575757575758 | 4.57575757575758
6 | 2016-05-09 03:20:00 | 5.3030303030303 |  |  |  | 4.81818181818182 | 4.81818181818182
5 | 2016-05-16 09:55:00 | 5.54545454545455 |  |  |  | 6.75757575757576 | 6.75757575757576
4 | 2016-05-23 07:45:00 | 5.78787878787879 |  |  |  | 7 | 7
3 | 2016-05-30 09:55:00 | 6.03030303030303 |  |  |  | 7.24242424242424 | 7.24242424242424
2 | 2016-06-06 07:20:00 | 6.27272727272727 |  |  |  | 9.66666666666667 | 9.66666666666667
1 | 2016-06-13 08:30:00 | 6.51515151515152 |  |  |  | 9.90909090909091 | 9.90909090909091
10 | 2016-04-11 07:35:00 | 6.75757575757576 |  |  |  | May | 1526.181818181818
9 | 2016-04-18 09:35:00 | 7 |  |  |  | 1 | 1
8 | 2016-04-25 08:20:00 | 7.24242424242424 |  |  |  | 2 | 2
7 | 2016-05-02 08:45:00 | 7.48484848484849 |  |  |  | 3 | 3
6 | 2016-05-09 03:20:00 | 7.72727272727273 |  |  |  | 4 | 4
5 | 2016-05-16 09:55:00 | 7.96969696969697 |  |  |  | 5 | 5
4 | 2016-05-23 07:45:00 | 8.21212121212121 |  |  |  | 5.06060606060606 | 5.06060606060606
3 | 2016-05-30 09:55:00 | 8.45454545454545 |  |  |  | 5.3030303030303 | 5.3030303030303
2 | 2016-06-06 07:20:00 | 8.6969696969697 |  |  |  | 5.54545454545455 | 5.54545454545455
1 | 2016-06-13 08:30:00 | 8.93939393939394 |  |  |  | 5.78787878787879 | 5.78787878787879
10 | 2016-03-14 08:40:00 | 9.18181818181818 |  |  |  | 6.03030303030303 | 6.03030303030303
9 | 2016-03-21 08:45:00 | 9.42424242424242 |  |  |  | 7.48484848484849 | 7.48484848484849
8 | 2016-04-01 08:30:00 | 9.66666666666667 |  |  |  | 7.72727272727273 | 7.72727272727273
7 | 2016-04-18 09:35:00 | 9.90909090909091 |  |  |  | 7.96969696969697 | 7.96969696969697
6 | 2016-05-02 08:45:00 | 10.1515151515152 |  |  |  | 8.21212121212121 | 8.21212121212121
5 | 2016-05-09 03:20:00 | 10.3939393939394 |  |  |  | 8.45454545454545 | 8.45454545454545
4 | 2016-05-16 09:55:00 | 10.6363636363636 |  |  |  | 10.1515151515152 | 10.1515151515152
3 | 2016-05-23 07:45:00 | 10.8787878787879 |  |  |  | 10.3939393939394 | 10.3939393939394
2 | 2016-05-30 09:55:00 | 11.1212121212121 |  |  |  | 10.6363636363636 | 10.6363636363636
1 | 2016-06-06 07:20:00 | 11.3636363636364 |  |  |  | 10.8787878787879 | 10.8787878787879
10 | 2016-05-23 07:45:00 | 11.6060606060606 |  |  |  | 11.1212121212121 | 11.1212121212121
9 | 2016-05-25 09:20:00 | 11.8484848484848 |  |  |  | 11.6060606060606 | 11.6060606060606
8 | 2016-05-27 09:45:00 | 12.0909090909091 |  |  |  | 11.8484848484848 | 11.8484848484848
7 | 2016-05-30 09:55:00 | 12.3333333333333 |  |  |  | 12.0909090909091 | 12.0909090909091
6 | 2016-06-01 09:30:00 | 12.5757575757576 |  |  |  | 12.3333333333333 | 12.3333333333333
5 | 2016-06-03 08:05:00 | 12.8181818181818 |  |  |  | 14.030303030303 | 14.030303030303
4 | 2016-06-06 07:20:00 | 13.060606060606 |  |  |  | 14.2727272727273 | 14.2727272727273
3 | 2016-06-08 08:45:00 | 13.3030303030303 |  |  |  | 14.5151515151515 | 14.5151515151515
2 | 2016-06-10 13:20:00 | 13.5454545454545 |  |  |  | 14.7575757575757 | 14.7575757575757
1 | 2016-06-13 08:30:00 | 13.7878787878788 |  |  |  | 16.4545454545454 | 16.4545454545454
10 | 2016-05-23 07:45:00 | 14.030303030303 |  |  |  | 16.6969696969697 | 16.6969696969697
9 | 2016-05-25 09:20:00 | 14.2727272727273 |  |  |  | 16.9393939393939 | 16.9393939393939
8 | 2016-05-27 09:45:00 | 14.5151515151515 |  |  |  | 17.1818181818182 | 17.1818181818182
7 | 2016-05-30 09:55:00 | 14.7575757575757 |  |  |  | 18.8787878787879 | 18.8787878787879
6 | 2016-06-01 09:30:00 | 15 |  |  |  | 19.1212121212121 | 19.1212121212121
5 | 2016-06-03 08:05:00 | 15.2424242424242 |  |  |  | 19.3636363636363 | 19.3636363636363
4 | 2016-06-06 07:20:00 | 15.4848484848485 |  |  |  | 19.6060606060606 | 19.6060606060606
3 | 2016-06-08 08:45:00 | 15.7272727272727 |  |  |  | 21.3030303030303 | 21.3030303030303
2 | 2016-06-10 13:20:00 | 15.969696969697 |  |  |  | 21.5454545454545 | 21.5454545454545
1 | 2016-06-13 08:30:00 | 16.2121212121212 |  |  |  | 21.7878787878788 | 21.7878787878788
10 | 2016-05-23 07:45:00 | 16.4545454545454 |  |  |  | 22.030303030303 | 22.030303030303
9 | 2016-05-25 09:20:00 | 16.6969696969697 |  |  |  | 23.7272727272727 | 23.7272727272727
8 | 2016-05-27 09:45:00 | 16.9393939393939 |  |  |  | 23.969696969697 | 23.969696969697
7 | 2016-05-30 09:55:00 | 17.1818181818182 |  |  |  | 24.2121212121212 | 24.2121212121212
6 | 2016-06-01 09:30:00 | 17.4242424242424 |  |  |  | 24.4545454545454 | 24.4545454545454
5 | 2016-06-03 08:05:00 | 17.6666666666667 |  |  |  | 26.1515151515151 | 26.1515151515151
4 | 2016-06-06 07:20:00 | 17.9090909090909 |  |  |  | 26.3939393939394 | 26.3939393939394
3 | 2016-06-08 08:45:00 | 18.1515151515151 |  |  |  | 26.6363636363636 | 26.6363636363636
2 | 2016-06-10 13:20:00 | 18.3939393939394 |  |  |  | 26.8787878787879 | 26.8787878787879
1 | 2016-06-13 08:30:00 | 18.6363636363636 |  |  |  | 29.060606060606 | 29.060606060606
10 | 2016-05-23 07:45:00 | 18.8787878787879 |  |  |  | 29.3030303030303 | 29.3030303030303
9 | 2016-05-25 09:20:00 | 19.1212121212121 |  |  |  | 29.5454545454545 | 29.5454545454545
8 | 2016-05-27 09:45:00 | 19.3636363636363 |  |  |  | 29.7878787878788 | 29.7878787878788
7 | 2016-05-30 09:55:00 | 19.6060606060606 |  |  |  | 31.4848484848485 | 31.4848484848485
6 | 2016-06-01 09:30:00 | 19.8484848484848 |  |  |  | 31.7272727272727 | 31.7272727272727
5 | 2016-06-03 08:05:00 | 20.0909090909091 |  |  |  | 31.969696969697 | 31.969696969697
4 | 2016-06-06 07:20:00 | 20.3333333333333 |  |  |  | 32.2121212121212 | 32.2121212121212
3 | 2016-06-08 08:45:00 | 20.5757575757576 |  |  |  | 33.9090909090909 | 33.9090909090909
2 | 2016-06-10 13:20:00 | 20.8181818181818 |  |  |  | 34.1515151515151 | 34.1515151515151
1 | 2016-06-13 08:30:00 | 21.060606060606 |  |  |  | 34.3939393939394 | 34.3939393939394
10 | 2016-05-23 07:45:00 | 21.3030303030303 |  |  |  | 34.6363636363636 | 34.6363636363636
9 | 2016-05-25 09:20:00 | 21.5454545454545 |  |  |  | 36.3333333333333 | 36.3333333333333
8 | 2016-05-27 09:45:00 | 21.7878787878788 |  |  |  | 36.5757575757576 | 36.5757575757576
7 | 2016-05-30 09:55:00 | 22.030303030303 |  |  |  | 36.8181818181818 | 36.8181818181818
6 | 2016-06-01 09:30:00 | 22.2727272727273 |  |  |  | 37.060606060606 | 37.060606060606
5 | 2016-06-03 08:05:00 | 22.5151515151515 |  |  |  | 38.7575757575757 | 38.7575757575757
4 | 2016-06-06 07:20:00 | 22.7575757575757 |  |  |  | 39 | 39
3 | 2016-06-08 08:45:00 | 23 |  |  |  | 39.2424242424242 | 39.2424242424242
2 | 2016-06-10 13:20:00 | 23.2424242424242 |  |  |  | 39.4848484848485 | 39.4848484848485
1 | 2016-06-13 08:30:00 | 23.4848484848485 |  |  |  | 41.1818181818182 | 41.1818181818182
10 | 2016-05-23 08:45:00 | 23.7272727272727 |  |  |  | 41.4242424242424 | 41.4242424242424
9 | 2016-05-25 08:45:00 | 23.969696969697 |  |  |  | 41.6666666666667 | 41.6666666666667
8 | 2016-05-27 10:20:00 | 24.2121212121212 |  |  |  | 41.9090909090909 | 41.9090909090909
7 | 2016-05-30 09:20:00 | 24.4545454545454 |  |  |  | Jun | 2230.969696969697
6 | 2016-06-01 09:10:00 | 24.6969696969697 |  |  |  | 4 | 4
5 | 2016-06-03 10:19:00 | 24.9393939393939 |  |  |  | 5 | 5
4 | 2016-06-06 09:55:00 | 25.1818181818182 |  |  |  | 6.27272727272727 | 6.27272727272727
3 | 2016-06-08 09:08:00 | 25.4242424242424 |  |  |  | 6.51515151515152 | 6.51515151515152
2 | 2016-06-10 09:15:00 | 25.6666666666667 |  |  |  | 8.6969696969697 | 8.6969696969697
1 | 2016-06-13 09:25:00 | 25.9090909090909 |  |  |  | 8.93939393939394 | 8.93939393939394
10 | 2016-05-23 08:45:00 | 26.1515151515151 |  |  |  | 11.3636363636364 | 11.3636363636364
9 | 2016-05-25 08:45:00 | 26.3939393939394 |  |  |  | 12.5757575757576 | 12.5757575757576
8 | 2016-05-27 10:20:00 | 26.6363636363636 |  |  |  | 12.8181818181818 | 12.8181818181818
7 | 2016-05-30 09:20:00 | 26.8787878787879 |  |  |  | 13.060606060606 | 13.060606060606
6 | 2016-06-01 09:10:00 | 27.1212121212121 |  |  |  | 13.3030303030303 | 13.3030303030303
5 | 2016-06-03 10:19:00 | 27.3636363636363 |  |  |  | 13.5454545454545 | 13.5454545454545
4 | 2016-06-06 09:55:00 | 27.6060606060606 |  |  |  | 13.7878787878788 | 13.7878787878788
3 | 2016-06-08 09:08:00 | 27.8484848484848 |  |  |  | 15 | 15
2 | 2016-06-10 09:15:00 | 28.0909090909091 |  |  |  | 15.2424242424242 | 15.2424242424242
1 | 2016-06-13 09:25:00 | 28.3333333333333 |  |  |  | 15.4848484848485 | 15.4848484848485
2 | 2010-08-09 09:15:00 | 28.5757575757576 |  |  |  | 15.7272727272727 | 15.7272727272727
1 | 2012-02-20 10:10:00 | 28.8181818181818 |  |  |  | 15.969696969697 | 15.969696969697
10 | 2016-05-23 08:45:00 | 29.060606060606 |  |  |  | 16.2121212121212 | 16.2121212121212
9 | 2016-05-25 08:45:00 | 29.3030303030303 |  |  |  | 17.4242424242424 | 17.4242424242424
8 | 2016-05-27 10:20:00 | 29.5454545454545 |  |  |  | 17.6666666666667 | 17.6666666666667
7 | 2016-05-30 09:20:00 | 29.7878787878788 |  |  |  | 17.9090909090909 | 17.9090909090909
6 | 2016-06-01 09:10:00 | 30.030303030303 |  |  |  | 18.1515151515151 | 18.1515151515151
5 | 2016-06-03 10:19:00 | 30.2727272727273 |  |  |  | 18.3939393939394 | 18.3939393939394
4 | 2016-06-06 09:55:00 | 30.5151515151515 |  |  |  | 18.6363636363636 | 18.6363636363636
3 | 2016-06-08 09:08:00 | 30.7575757575757 |  |  |  | 19.8484848484848 | 19.8484848484848
2 | 2016-06-10 09:15:00 | 31 |  |  |  | 20.0909090909091 | 20.0909090909091
1 | 2016-06-13 09:25:00 | 31.2424242424242 |  |  |  | 20.3333333333333 | 20.3333333333333
10 | 2016-05-23 08:45:00 | 31.4848484848485 |  |  |  | 20.5757575757576 | 20.5757575757576
9 | 2016-05-25 08:45:00 | 31.7272727272727 |  |  |  | 20.8181818181818 | 20.8181818181818
8 | 2016-05-27 10:20:00 | 31.969696969697 |  |  |  | 21.060606060606 | 21.060606060606
7 | 2016-05-30 09:20:00 | 32.2121212121212 |  |  |  | 22.2727272727273 | 22.2727272727273
6 | 2016-06-01 09:10:00 | 32.4545454545454 |  |  |  | 22.5151515151515 | 22.5151515151515
5 | 2016-06-03 10:19:00 | 32.6969696969697 |  |  |  | 22.7575757575757 | 22.7575757575757
4 | 2016-06-06 09:55:00 | 32.9393939393939 |  |  |  | 23 | 23
3 | 2016-06-08 09:08:00 | 33.1818181818182 |  |  |  | 23.2424242424242 | 23.2424242424242
2 | 2016-06-10 09:15:00 | 33.4242424242424 |  |  |  | 23.4848484848485 | 23.4848484848485
1 | 2016-06-13 09:25:00 | 33.6666666666667 |  |  |  | 24.6969696969697 | 24.6969696969697
10 | 2016-05-23 08:45:00 | 33.9090909090909 |  |  |  | 24.9393939393939 | 24.9393939393939
9 | 2016-05-25 08:45:00 | 34.1515151515151 |  |  |  | 25.1818181818182 | 25.1818181818182
8 | 2016-05-27 10:20:00 | 34.3939393939394 |  |  |  | 25.4242424242424 | 25.4242424242424
7 | 2016-05-30 09:20:00 | 34.6363636363636 |  |  |  | 25.6666666666667 | 25.6666666666667
6 | 2016-06-01 09:10:00 | 34.8787878787879 |  |  |  | 25.9090909090909 | 25.9090909090909
5 | 2016-06-03 10:19:00 | 35.1212121212121 |  |  |  | 27.1212121212121 | 27.1212121212121
4 | 2016-06-06 09:55:00 | 35.3636363636363 |  |  |  | 27.3636363636363 | 27.3636363636363
3 | 2016-06-08 09:08:00 | 35.6060606060606 |  |  |  | 27.6060606060606 | 27.6060606060606
2 | 2016-06-10 09:15:00 | 35.8484848484848 |  |  |  | 27.8484848484848 | 27.8484848484848
1 | 2016-06-13 09:25:00 | 36.0909090909091 |  |  |  | 28.0909090909091 | 28.0909090909091
10 | 2016-05-23 08:45:00 | 36.3333333333333 |  |  |  | 28.3333333333333 | 28.3333333333333
9 | 2016-05-25 08:45:00 | 36.5757575757576 |  |  |  | 30.030303030303 | 30.030303030303
8 | 2016-05-27 10:20:00 | 36.8181818181818 |  |  |  | 30.2727272727273 | 30.2727272727273
7 | 2016-05-30 09:20:00 | 37.060606060606 |  |  |  | 30.5151515151515 | 30.5151515151515
6 | 2016-06-01 09:10:00 | 37.3030303030303 |  |  |  | 30.7575757575757 | 30.7575757575757
5 | 2016-06-03 10:19:00 | 37.5454545454545 |  |  |  | 31 | 31
4 | 2016-06-06 09:55:00 | 37.7878787878788 |  |  |  | 31.2424242424242 | 31.2424242424242
3 | 2016-06-08 09:08:00 | 38.030303030303 |  |  |  | 32.4545454545454 | 32.4545454545454
2 | 2016-06-10 09:15:00 | 38.2727272727273 |  |  |  | 32.6969696969697 | 32.6969696969697
1 | 2016-06-13 09:25:00 | 38.5151515151515 |  |  |  | 32.9393939393939 | 32.9393939393939
10 | 2016-05-23 08:45:00 | 38.7575757575757 |  |  |  | 33.1818181818182 | 33.1818181818182
9 | 2016-05-25 08:45:00 | 39 |  |  |  | 33.4242424242424 | 33.4242424242424
8 | 2016-05-27 10:20:00 | 39.2424242424242 |  |  |  | 33.6666666666667 | 33.6666666666667
7 | 2016-05-30 09:20:00 | 39.4848484848485 |  |  |  | 34.8787878787879 | 34.8787878787879
6 | 2016-06-01 09:10:00 | 39.7272727272727 |  |  |  | 35.1212121212121 | 35.1212121212121
5 | 2016-06-03 10:19:00 | 39.969696969697 |  |  |  | 35.3636363636363 | 35.3636363636363
4 | 2016-06-06 09:55:00 | 40.2121212121212 |  |  |  | 35.6060606060606 | 35.6060606060606
3 | 2016-06-08 09:08:00 | 40.4545454545454 |  |  |  | 35.8484848484848 | 35.8484848484848
2 | 2016-06-10 09:15:00 | 40.6969696969697 |  |  |  | 36.0909090909091 | 36.0909090909091
1 | 2016-06-13 09:25:00 | 40.9393939393939 |  |  |  | 37.3030303030303 | 37.3030303030303
10 | 2016-05-23 08:45:00 | 41.1818181818182 |  |  |  | 37.5454545454545 | 37.5454545454545
9 | 2016-05-25 08:45:00 | 41.4242424242424 |  |  |  | 37.7878787878788 | 37.7878787878788
8 | 2016-05-27 10:20:00 | 41.6666666666667 |  |  |  | 38.030303030303 | 38.030303030303
7 | 2016-05-30 09:20:00 | 41.9090909090909 |  |  |  | 38.2727272727273 | 38.2727272727273
6 | 2016-06-01 09:10:00 | 42.1515151515151 |  |  |  | 38.5151515151515 | 38.5151515151515
5 | 2016-06-03 10:19:00 | 42.3939393939394 |  |  |  | 39.7272727272727 | 39.7272727272727
4 | 2016-06-06 09:55:00 | 42.6363636363636 |  |  |  | 39.969696969697 | 39.969696969697
3 | 2016-06-08 09:08:00 | 42.8787878787879 |  |  |  | 40.2121212121212 | 40.2121212121212
2 | 2016-06-10 09:15:00 | 43.1212121212121 |  |  |  | 40.4545454545454 | 40.4545454545454
1 | 2016-06-13 09:25:00 | 43.3636363636363 |  |  |  | 40.6969696969697 | 40.6969696969697
 |  |  |  |  |  | 40.9393939393939 | 40.9393939393939
 |  |  |  |  |  | 42.1515151515151 | 42.1515151515151
 |  |  |  |  |  | 42.3939393939394 | 42.3939393939394
 |  |  |  |  |  | 42.6363636363636 | 42.6363636363636
 |  |  |  |  |  | 42.8787878787879 | 42.8787878787879
 |  |  |  |  |  | 43.1212121212121 | 43.1212121212121
 |  |  |  |  |  | 43.3636363636363 | 43.3636363636363
 |  |  |  |  |  | Grand Total | 3893.454545454544