Spreadsheet: 159761d1338836499-excel-2007-help-with-formula-to-find-previous-value-in-column-sample-file
Sheet: Sample

Date | Open | High | Low | Close | UTL
2012-01-03 00:00:00 | 127.76 | 128.38 | 127.43 | 127.5
2012-01-04 00:00:00 | 127.2 | 127.81 | 126.71 | 127.7
2012-01-05 00:00:00 | 127.01 | 128.23 | 126.43 | 128.04 | 126.43
2012-01-06 00:00:00 | 128.2 | 128.22 | 127.29 | 127.71
2012-01-09 00:00:00 | 128 | 128.18 | 127.41 | 128.02
2012-01-10 00:00:00 | 129.39 | 129.65 | 128.95 | 129.13
2012-01-11 00:00:00 | 128.73 | 129.37 | 128.52 | 129.2 | 128.52
2012-01-12 00:00:00 | 129.57 | 129.7 | 128.54 | 129.51
2012-01-13 00:00:00 | 128.64 | 129.05 | 127.72 | 128.84 | 127.72
2012-01-17 00:00:00 | 130.08 | 130.32 | 128.9 | 129.34
2012-01-18 00:00:00 | 129.31 | 130.84 | 129.08 | 130.77
2012-01-19 00:00:00 | 131.22 | 131.57 | 130.8 | 131.46
2012-01-20 00:00:00 | 131.24 | 131.95 | 130.92 | 131.54
2012-01-23 00:00:00 | 131.51 | 132.25 | 130.98 | 131.61
2012-01-24 00:00:00 | 130.8 | 131.5 | 130.6 | 131.46 | 130.6
2012-01-25 00:00:00 | 131.26 | 132.87 | 130.75 | 132.56
2012-01-26 00:00:00 | 133.15 | 133.4 | 131.36 | 131.88
2012-01-27 00:00:00 | 131.24 | 132.05 | 131.15 | 131.83
2012-01-30 00:00:00 | 130.51 | 131.44 | 130.06 | 131.37 | 130.06
2012-01-31 00:00:00 | 132.02 | 132.18 | 130.68 | 131.32
2012-02-01 00:00:00 | 132.29 | 133.14 | 132.13 | 132.47
2012-02-02 00:00:00 | 132.73 | 133.02 | 132.21 | 132.68
2012-02-03 00:00:00 | 134 | 134.62 | 133.77 | 134.54
2012-02-06 00:00:00 | 133.98 | 134.51 | 133.83 | 134.45
2012-02-07 00:00:00 | 134.17 | 135.02 | 133.64 | 134.79 | 133.64
2012-02-08 00:00:00 | 134.86 | 135.22 | 134.31 | 135.19
2012-02-09 00:00:00 | 135.41 | 135.59 | 134.56 | 135.36
2012-02-10 00:00:00 | 134.16 | 134.47 | 133.84 | 134.36 | 133.84
2012-02-13 00:00:00 | 135.32 | 135.52 | 134.74 | 135.35
2012-02-14 00:00:00 | 135 | 135.27 | 134.25 | 135.19 | 134.25
2012-02-15 00:00:00 | 135.63 | 135.83 | 134.29 | 134.56
2012-02-16 00:00:00 | 134.57 | 136.17 | 134.33 | 136.05
2012-02-17 00:00:00 | 136.52 | 136.63 | 135.96 | 136.41
2012-02-21 00:00:00 | 136.73 | 137.05 | 136.05 | 136.47
2012-02-22 00:00:00 | 136.26 | 136.55 | 135.79 | 136.03
2012-02-23 00:00:00 | 135.96 | 136.73 | 135.5 | 136.63 | 135.5
2012-02-24 00:00:00 | 136.93 | 137.2 | 136.63 | 136.93
2012-02-27 00:00:00 | 136.02 | 137.53 | 135.8 | 137.16 | 135.8
2012-02-28 00:00:00 | 137.2 | 137.72 | 136.93 | 137.56
2012-02-29 00:00:00 | 137.76 | 138.19 | 136.54 | 137.02 | 136.54
2012-03-01 00:00:00 | 137.31 | 137.99 | 136.93 | 137.73
2012-03-02 00:00:00 | 137.64 | 137.82 | 137 | 137.31
2012-03-05 00:00:00 | 137.1 | 137.2 | 136.28 | 136.75
2012-03-06 00:00:00 | 135.35 | 135.43 | 134.36 | 134.75 | 134.36
2012-03-07 00:00:00 | 135.06 | 135.91 | 134.93 | 135.69
2012-03-08 00:00:00 | 136.52 | 137.32 | 136.24 | 137.04
2012-03-09 00:00:00 | 137.3 | 137.93 | 137.13 | 137.57
2012-03-12 00:00:00 | 137.55 | 137.76 | 137.09 | 137.58 | 137.09
2012-03-13 00:00:00 | 138.32 | 140.13 | 138.09 | 140.06
2012-03-14 00:00:00 | 140.1 | 140.45 | 139.48 | 139.91
2012-03-15 00:00:00 | 140.12 | 140.78 | 139.76 | 140.72
2012-03-16 00:00:00 | 140.36 | 140.48 | 140 | 140.3
2012-03-19 00:00:00 | 140.21 | 141.28 | 140.11 | 140.85
2012-03-20 00:00:00 | 140.05 | 140.61 | 139.64 | 140.44 | 139.64
2012-03-21 00:00:00 | 140.52 | 140.65 | 139.92 | 140.21
2012-03-22 00:00:00 | 139.18 | 139.55 | 138.74 | 139.2
2012-03-23 00:00:00 | 139.32 | 139.81 | 138.55 | 139.65 | 138.55
2012-03-26 00:00:00 | 140.65 | 141.61 | 140.6 | 141.61
2012-03-27 00:00:00 | 141.74 | 141.83 | 141.08 | 141.17
2012-03-28 00:00:00 | 141.1 | 141.32 | 139.64 | 140.47
2012-03-29 00:00:00 | 139.64 | 140.49 | 139.09 | 140.23 | 139.09
2012-03-30 00:00:00 | 140.92 | 141.05 | 140.05 | 140.81
2012-04-02 00:00:00 | 140.64 | 142.21 | 140.36 | 141.84
2012-04-03 00:00:00 | 141.64 | 141.88 | 140.43 | 141.26
2012-04-04 00:00:00 | 140.22 | 140.34 | 139.34 | 139.86
2012-04-05 00:00:00 | 139.38 | 140.2 | 139.26 | 139.79
2012-04-09 00:00:00 | 138.03 | 139.84 | 137.84 | 138.22
2012-04-10 00:00:00 | 137.95 | 138.34 | 135.76 | 135.9 | 135.76
2012-04-11 00:00:00 | 137.29 | 137.54 | 136.75 | 137
2012-04-12 00:00:00 | 137.13 | 138.9 | 137.03 | 138.79
2012-04-13 00:00:00 | 138.47 | 138.82 | 137.01 | 137.14
2012-04-16 00:00:00 | 137.84 | 138.04 | 136.58 | 137.05 | 136.58
2012-04-17 00:00:00 | 137.84 | 139.36 | 137.7 | 139.08
2012-04-18 00:00:00 | 138.46 | 139.08 | 138.38 | 138.61
2012-04-19 00:00:00 | 138.63 | 139.15 | 137.07 | 137.72 | 137.07
2012-04-20 00:00:00 | 138.33 | 138.83 | 137.87 | 137.95
2012-04-23 00:00:00 | 136.54 | 136.91 | 135.94 | 136.79 | 135.94
2012-04-24 00:00:00 | 136.91 | 137.66 | 136.8 | 137.31
2012-04-25 00:00:00 | 138.65 | 139.25 | 138.53 | 139.19
2012-04-26 00:00:00 | 138.89 | 140.32 | 138.81 | 140.16
2012-04-27 00:00:00 | 140.58 | 140.79 | 139.8 | 140.39
2012-04-30 00:00:00 | 140.11 | 140.21 | 139.49 | 139.87 | 139.49
2012-05-01 00:00:00 | 139.79 | 141.66 | 139.63 | 140.74
2012-05-02 00:00:00 | 139.92 | 140.46 | 139.46 | 140.32
2012-05-03 00:00:00 | 140.34 | 140.45 | 138.99 | 139.25
2012-05-04 00:00:00 | 138.52 | 139.3 | 136.92 | 137
2012-05-07 00:00:00 | 136.51 | 137.56 | 136.46 | 137.1
2012-05-08 00:00:00 | 136.28 | 136.77 | 134.92 | 136.55
2012-05-09 00:00:00 | 135.1 | 136.61 | 134.49 | 135.74 | 134.49
2012-05-10 00:00:00 | 136.68 | 136.85 | 135.71 | 136.02
2012-05-11 00:00:00 | 135.17 | 136.87 | 135.11 | 135.61
2012-05-14 00:00:00 | 134.31 | 135.61 | 133.91 | 134.11
2012-05-15 00:00:00 | 134.11 | 134.81 | 133.13 | 133.34
2012-05-16 00:00:00 | 133.94 | 134.55 | 132.8 | 132.83
2012-05-17 00:00:00 | 132.86 | 133.02 | 130.79 | 130.86
2012-05-18 00:00:00 | 131.37 | 131.6 | 129.55 | 129.74 | 129.55 | 127.72
2012-05-21 00:00:00 | 130.16 | 132.02 | 129.95 | 131.97
2012-05-22 00:00:00 | 132.31 | 133.23 | 131.34 | 132.2
2012-05-23 00:00:00 | 131.25 | 132.46 | 129.99 | 132.27 | 129.99 | 129.55
2012-05-24 00:00:00 | 132.63 | 132.84 | 131.42 | 132.53
2012-05-25 00:00:00 | 132.48 | 132.85 | 131.78 | 132.1
2012-05-29 00:00:00 | 133.16 | 133.93 | 131.17 | 133.7 | 131.17 | 129.99
2012-05-30 00:00:00 | 132.56 | 133.69 | 131.49 | 131.76
2012-05-31 00:00:00 | 131.71 | 132.45 | 130.34 | 131.47
2012-06-01 00:00:00 | 129.41 | 131.5 | 128.16 | 128.16
2012-06-04 00:00:00