Your first formula worked GREAT, perfect. But the 2nd one did not (?) Here is my actual table, hope this helps explain it better.
<tbody>
[TD="class: xl65"]SPL[/TD]
[TD="class: xl65, width: 80"]SPL High[/TD]
[TD="class: xl66, width: 80"]High[/TD]
[TD="class: xl66, width: 80"]Close[/TD]
[TD="class: xl66, width: 80"]Closed Under SPL[/TD]
[TD="class: xl66, width: 80"]Closed Over High[/TD]
[TD="class: xl67, width: 512"][/TD]
[TD="class: xl68, width: 80"]262.71[/TD]
[TD="class: xl65, width: 80"]263.73[/TD]
[TD="class: xl66, width: 80"][/TD]
[TD="class: xl66, width: 80"][/TD]
[TD="class: xl66, width: 80"][/TD]
[TD="class: xl66, width: 80"][/TD]
[TD="class: xl67, width: 512"][/TD]
[TD="class: xl69, width: 80"][/TD]
[TD="class: xl69, width: 80"][/TD]
[TD="class: xl70, width: 80"]264.43[/TD]
[TD="class: xl82, width: 80"]264.07[/TD]
[TD="class: xl71, width: 80"][/TD]
[TD="class: xl72, align: right"]264.07[/TD]
[TD="class: xl74, width: 512"]Your formula returned this, it isn't right[/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]265.52[/TD]
[TD="class: xl73, width: 80, align: right"]265.51[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]266.38[/TD]
[TD="class: xl73, width: 80, align: right"]266.31[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]267.32[/TD]
[TD="class: xl73, width: 80, align: right"]266.78[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]267.56[/TD]
[TD="class: xl73, width: 80, align: right"]266.75[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]267.22[/TD]
[TD="class: xl73, width: 80, align: right"]265.66[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]267.04[/TD]
[TD="class: xl73, width: 80, align: right"]266.51[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]268.60[/TD]
[TD="class: xl73, width: 80, align: right"]268.20[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]268.53[/TD]
[TD="class: xl73, width: 80, align: right"]267.17[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]268.33[/TD]
[TD="class: xl73, width: 80, align: right"]267.03[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]268.39[/TD]
[TD="class: xl73, width: 80, align: right"]267.58[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]267.64[/TD]
[TD="class: xl73, width: 80, align: right"]267.51[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]267.64[/TD]
[TD="class: xl73, width: 80, align: right"]267.51[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]267.44[/TD]
[TD="class: xl73, width: 80, align: right"]267.19[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]267.73[/TD]
[TD="class: xl73, width: 80, align: right"]267.32[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]267.92[/TD]
[TD="class: xl73, width: 80, align: right"]267.87[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]268.55[/TD]
[TD="class: xl73, width: 80, align: right"]266.86[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]270.64[/TD]
[TD="class: xl73, width: 80, align: right"]270.47[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]272.16[/TD]
[TD="class: xl73, width: 80, align: right"]271.61[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]273.56[/TD]
[TD="class: xl73, width: 80, align: right"]273.42[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]274.10[/TD]
[TD="class: xl73, width: 80, align: right"]273.92[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]275.25[/TD]
[TD="class: xl73, width: 80, align: right"]274.54[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]274.42[/TD]
[TD="class: xl73, width: 80, align: right"]274.12[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]276.12[/TD]
[TD="class: xl73, width: 80, align: right"]276.12[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]278.11[/TD]
[TD="class: xl73, width: 80, align: right"]277.92[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]280.05[/TD]
[TD="class: xl73, width: 80, align: right"]279.61[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]279.96[/TD]
[TD="class: xl73, width: 80, align: right"]279.14[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]280.41[/TD]
[TD="class: xl73, width: 80, align: right"]280.41[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]282.69[/TD]
[TD="class: xl73, width: 80, align: right"]282.69[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]283.62[/TD]
[TD="class: xl73, width: 80, align: right"]283.29[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]284.70[/TD]
[TD="class: xl73, width: 80, align: right"]283.18[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]284.27[/TD]
[TD="class: xl73, width: 80, align: right"]283.30[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]286.63[/TD]
[TD="class: xl73, width: 80, align: right"]286.58[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]286.43[/TD]
[TD="class: xl73, width: 80, align: right"]284.68[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]284.74[/TD]
[TD="class: xl73, width: 80, align: right"]281.76[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]283.30[/TD]
[TD="class: xl73, width: 80, align: right"]281.90[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]283.06[/TD]
[TD="class: xl73, width: 80, align: right"]281.58[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]280.23[/TD]
[TD="class: xl73, width: 80, align: right"]275.45[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]275.85[/TD]
[TD="class: xl73, width: 80, align: right"]263.93[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]269.70[/TD]
[TD="class: xl79, width: 80, align: right"]269.13[/TD]
[TD="class: xl67, width: 80, align: right"]257.63[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl77, width: 80, align: right"]272.36[/TD]
[TD="class: xl81, width: 80, align: right"]267.67[/TD]
[TD="class: xl78, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl76, width: 512"]should be 267.67 because it came AFTER the 257.63[/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]268.17[/TD]
[TD="class: xl80, width: 80, align: right"]257.63[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl75, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]263.61[/TD]
[TD="class: xl73, width: 80, align: right"]261.50[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]267.01[/TD]
[TD="class: xl73, width: 80, align: right"]265.34[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]266.62[/TD]
[TD="class: xl73, width: 80, align: right"]266.00[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]270.00[/TD]
[TD="class: xl73, width: 80, align: right"]269.59[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]273.04[/TD]
[TD="class: xl73, width: 80, align: right"]273.03[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]275.32[/TD]
[TD="class: xl73, width: 80, align: right"]273.11[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]274.72[/TD]
[TD="class: xl73, width: 80, align: right"]270.05[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80"][/TD]
[TD="class: xl73, width: 80, align: right"]273.05[/TD]
[TD="class: xl73, width: 80, align: right"]270.40[/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl67, width: 80"][/TD]
[TD="class: xl74, width: 512"][/TD]
</tbody>