Spreadsheet: 745594d1630036935-add-conditional-array-to-simple-if-formula-that-includes-blank-cells-rd-excel-forum-question
Sheet: Retracement Long

0.017
 |  |  |  | Day One |  |  |  |  |  |  |  |  | Day Two |  |  |  |  |  | Day Three |  |  |  |  |  |  |  |  |  |  | [NAME] (See A1)
Symbol |  |  | Target % | Prev. Close | Open | High | Low | Close | Runup % | Close % |  | DD % | Open | High | Close | Open % | Runup | Close % | Open | High | Close | Open % | Runup | Close % |  |  |  |  |  | Day One | Day Two | Day Three
BBBY |  |  |  | 27.93 | 24.07 | 25.89 | 23.68 | 24.52 |  |  |  |  | 24.58 | 24.62 | 24.54 |  |  |  | 24.18 | 25.96 | 25.52 |  |  |  |  |  |  | 2
SLP |  |  |  | 60.95 | 61.07 | 63.32 | 61.07 | 61.87 |  |  |  |  | 62.63 | 64.13 | 63.67 |  |  |  | 63.25 | 63.73 | 62.91 |  |  |  |  |  |  | 2.3
HIBB |  |  |  | 69.4 | 69.42 | 72.32 | 68.32 | 72.08 |  |  |  |  | 69.5 | 70.73 | 69.06 |  |  |  | 69.56 | 72.32 | 72.08 |  |  |  |  |  |  | 3
AX |  |  |  | 46.84 | 46.79 | 48.36 | 46.76 | 47.48 |  |  |  |  | 47.65 | 47.65 | 46.98 |  |  |  | 47.67 | 47.67 | 46.72 |  |  |  |  |  |  | 2.3
BJRI |  |  |  | 58.27 | 58.5 | 60.55 | 58.5 | 59.37 |  |  |  |  | 60.43 | 60.64 | 58.83 |  |  |  | 59.68 | 60.56 | 58.69 |  |  |  |  |  |  | 2.6
BXS |  |  |  | 30.24 | 30.33 | 31.72 | 30.21 | 31.14 |  |  |  |  | 31.21 | 31.33 | 31.21 |  |  |  | 31.78 | 31.91 | 31.16 |  |  |  |  |  |  | 3
X |  |  |  | 22.87 | 23.32 | 23.55 | 21.67 | 22.15 |  |  |  |  | 22.4 | 22.84 | 22.67 |  |  |  | 22.56 | 23.93 | 22.84 |  |  |  |  |  |  | 7
SM |  |  |  | 16.14 | 16.3 | 17.45 | 16.18 | 16.96 |  |  |  |  | 16.77 | 16.81 | 16.21 |  |  |  | 15.53 | 16.46 | 16.17 |  |  |  |  |  |  | 1.5
MYGN |  |  |  | 27.31 | 27.13 | 27.49 | 26.55 | 27.22 |  |  |  |  | 27.24 | 27.31 | 26.61 |  |  |  | 26.37 | 28.12 | 28.11 |  |  |  |  |  |  | 3.8
LRCX |  |  |  | 621.73 | 616.74 | 625.09 | 608.2 | 613.03 |  |  |  |  | 619.58 | 641.25 | 641.25 |  |  |  | 643.9 | 649.94 | 614.54 |  |  |  |  |  |  | 1.7
MU |  |  |  | 88.41 | 88.38 | 88.95 | 86.53 | 87.48 |  |  |  |  | 87.06 | 89.56 | 89.49 |  |  |  | 88.2 | 88.36 | 84.71 |  |  |  |  |  |  | 1.6
RUN |  |  |  | 48.54 | 48.6 | 50.5 | 47.02 | 48.23 |  |  |  |  | 47 | 52.5 | 52.22 |  |  |  | 53.99 | 55.05 | 53.1 |  |  |  |  |  |  | 3.3
SEDG |  |  |  | 244.86 | 243.03 | 249.12 | 237.31 | 243.87 |  |  |  |  | 240.69 | 257 | 255.09 |  |  |  | 267.57 | 279.44 | 274.7 |  |  |  |  |  |  | 3.5
QDEL |  |  |  | 122.32 | 122.3 | 122.82 | 117.75 | 119.51 |  |  |  |  | 118.72 | 120.92 | 119.01 |  |  |  | 119.95 | 124.83 | 122.22 |  |  |  |  |  |  | 3
ODP |  |  |  | 39.66 | 39.66 | 39.66 | 37.86 | 38.7 |  |  |  |  | 38.64 | 39.31 | 38.8 |  |  |  | 39.13 | 40.74 | 39.37 |  |  |  |  |  |  | 2.6
REGI |  |  |  | 61.81 | 61.39 | 61.95 | 57.97 | 58.88 |  |  |  |  | 58.5 | 60.18 | 60.11 |  |  |  | 60.6 | 61.03 | 57.63 |  |  |  |  |  |  | 3.3
KLIC |  |  |  | 52.12 | 52.33 | 53.4 | 51.17 | 52.06 |  |  |  |  | 52.01 | 54.19 | 53.93 |  |  |  | 54 | 54.79 | 53.74 |  |  |  |  |  |  | 2.6
UCTT |  |  |  | 51.66 | 51.69 | 51.92 | 49.55 | 50.44 |  |  |  |  | 50.54 | 52.93 | 52.85 |  |  |  | 53.16 | 53.5 | 52.18 |  |  |  |  |  |  | 4
DVN |  |  |  | 20.97 | 20.14 | 21.38 | 20.14 | 21.17 |  |  |  |  | 21.03 | 21.11 | 20.77 |  |  |  | 20.94 | 21.33 | 21.21 |  |  |  |  |  |  | 2.3
NCLH |  |  |  | 26.75 | 27.16 | 29.54 | 26.84 | 29.51 |  |  |  |  | 29.31 | 30.35 | 29 |  |  |  | 29.33 | 30.02 | 29.81 |  |  |  |  |  |  | 2.7
RCL |  |  |  | 81.07 | 81.15 | 84.72 | 80.05 | 84.69 |  |  |  |  | 84.4 | 86.55 | 84.18 |  |  |  | 84.65 | 85.96 | 85.81 |  |  |  |  |  |  | 1.6
MAR |  |  |  | 141.97 | 141.7 | 145.4 | 140.87 | 144.76 |  |  |  |  | 144.67 | 149.27 | 146.64 |  |  |  | 147.04 | 148.72 | 148.36 |  |  |  |  |  |  | 2.8
APTV |  |  |  | 135.04 | 134.76 | 139.48 | 133.55 | 139.18 |  |  |  |  | 139.8 | 140.63 | 138.93 |  |  |  | 140.71 | 145.77 | 144.89 |  |  |  |  |  |  | 1.5
LEN |  |  |  | 100.1 | 100.24 | 102.48 | 100.01 | 101.98 |  |  |  |  | 101.04 | 101.46 | 100.75 |  |  |  | 101.27 | 102.5 | 101.86 |  |  |  |  |  |  | 2
TMHC |  |  |  | 30.89 | 30.79 | 31.45 | 30.79 | 31.39 |  |  |  |  | 31.45 | 31.48 | 31.24 |  |  |  | 31.26 | 31.85 | 31.57 |  |  |  |  |  |  | 2.4
CMA |  |  |  | 67.3 | 66.67 | 69.29 | 66.36 | 69.15 |  |  |  |  | 69.33 | 69.63 | 67.88 |  |  |  | 67.75 | 70.72 | 70.45 |  |  |  |  |  |  | 1.3
TRIP |  |  |  | 47.5 | 48.11 | 50.59 | 47.52 | 50.39 |  |  |  |  | 50.38 | 51.31 | 49.67 |  |  |  | 50.18 | 51.29 | 50.99 |  |  |  |  |  |  | 3.5
SABR |  |  |  | 14.4 | 14.34 | 15.23 | 14.13 | 15.21 |  |  |  |  | 15.25 | 15.99 | 15.4 |  |  |  | 15.5 | 15.67 | 15.57 |  |  |  |  |  |  | 3.2
CREE |  |  |  | 103.09 | 102.84 | 109.54 | 101.79 | 109.03 |  |  |  |  | 110.97 | 113.9 | 108.72 |  |  |  | 110.34 | 115.7 | 114.77 |  |  |  |  |  |  | 3.5
KSS |  |  |  | 56.7 | 56.83 | 59.57 | 56.2 | 59.17 |  |  |  |  | 59.26 | 60.06 | 58.36 |  |  |  | 59.05 | 59.73 | 59.47 |  |  |  |  |  |  | 1.8