Spreadsheet: 466277d1466093647-extract-unique-points-from-table-column-and-sort-by-smallest-to-largest-for-indexmatch-use-466271-extract-unique-points-from-table-column-and-sort-by-smallest-to-largest-for-indexmatch-u
Sheet: Sheet1

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