Spreadsheet: 743876d1628791246-stop-an-instance-of-a-formula-repeating-plot-schedule
Sheet: Plot Order All

 |  |  |  |  |  | I have highlighted a few occurances and what I would like to see.
 | Plot Schedule |  |  |  |  | This is what is happening |  | This is what I want it to do. So not add a semi and [NAME] together
 | PLOT | House type | [NAME]
 | 1 | The Lymner | [NAME] |  | 1 | The Lymner |  | 1 | The Lymner
 | 2 | The Cutler | [NAME] |  | 2 | The Cutler |  | 2 | The Cutler
 | 3 | The [NAME] | SEMI |  | 3 - 4 | The [NAME] - The Blacksmith |  | 3 - 4 | The [NAME] - The Blacksmith
 | 4 | The [NAME] | SEMI |  | 4 - 5 | The Blacksmith - The Thespian |  | 4 - 5 | The Blacksmith - The Thespian
 | 5 | The Thespian | SEMI |  | 5 - 6 | The Thespian - The Tailor |  | 5 - 6 | The Thespian - The Tailor
 | 6 | The Tailor | SEMI |  | 6 - 7 | The Tailor - The Coppersmith M4(2)
 | 7 | The Coppersmith M4(2) | [NAME] |  | 7 | The Coppersmith M4(2) |  | 7 | The Coppersmith M4(2)
 | 8 | The Cobbler M4(2) | [NAME] |  | 8 | The Cobbler M4(2) |  | 8 | The Cobbler M4(2)
 | 9 | The Mason | [NAME] |  | 9 | The Mason |  | 9 | The Mason
 | 10 | The Joiner | SEMI |  | 10 - 11 | The Joiner - The Joiner |  | 10 - 11 | The Joiner - The Joiner
 | 11 | The Joiner | SEMI |  | 11 - 12 | The Joiner - The Lymner |  | 11 - 12 | The Joiner - The Lymner
 | 12 | The Lymner | [NAME] |  | 12 | The Lymner |  | 12 | The Lymner
 | 13 | The Lymner | [NAME] |  | 13 | The Lymner |  | 13 | The Lymner
 | 14 | The Cobbler M4(2) | [NAME] |  | 14 | The Cobbler M4(2) |  | 14 | The Cobbler M4(2)
 | 15 | The Cutler | [NAME] |  | 15 | The Cutler |  | 15 | The Cutler
 | 16 | The [NAME] | SEMI |  | 16 - 17 | The [NAME] - The Blacksmith |  | 16 - 17 | The [NAME] - The Blacksmith
 | 17 | The [NAME] | SEMI |  | 17 - 18 | The Blacksmith - The Thespian |  | 17 - 18 | The Blacksmith - The Thespian
 | 18 | The Thespian | SEMI |  | 18 - 19 | The Thespian - The Tailor |  | 18 - 19 | The Thespian - The Tailor
 | 19 | The Tailor | SEMI |  | 19 - 20 | The Tailor - The Baxter
 | 20 | The Baxter | [NAME] |  | 20 | The Baxter |  | 20 | The Baxter
 | 21 | The Baxter | [NAME] |  | 21 | The Baxter |  | 21 | The Baxter
 | 22 | The Tailor | SEMI |  | 22 - 23 | The Tailor - The Tailor |  | 22 - 23 | The Tailor - The Tailor
 | 23 | The Tailor | SEMI |  | 23 - 24 | The Tailor - The Lymner
 | 24 | The Lymner | [NAME] |  | 24 | The Lymner |  | 24 | The Lymner
 | 25 | The Cobbler M4(2) | [NAME] |  | 25 | The Cobbler M4(2)
 | 26 | The Thespian | Semi |  | 26 - 27 | The Thespian - The Tailor
 | 27 | The Tailor | Semi |  | 27 - 28 | The Tailor - The Tailor
 | 28 | The Tailor | Semi |  | 28 - 29 | The Tailor - The Tailor
 | 29 | The Tailor | Semi |  | 29 - 30 | The Tailor - The Lymner
 | 30 | The Lymner | [NAME] |  | 30 | The Lymner
 | 31 | The Baxter | [NAME] |  | 31 | The Baxter
 | 32 | The [NAME] | SEMI |  | 32 - 33 | The [NAME] - The Blacksmith
 | 33 | The [NAME] | SEMI |  | 33 - 34 | The Blacksmith - The Joiner
 | 34 | The Joiner | SEMI |  | 34 - 35 | The Joiner - The Joiner
 | 35 | The Joiner | SEMI |  | 35 - 36 | The Joiner - The Lymner
 | 36 | The Lymner | [NAME] |  | 36 | The Lymner
 | 37 | The Joiner | SEMI |  | 37 - 38 | The Joiner - The Joiner
 | 38 | The Joiner | SEMI |  | 38 - 39 | The Joiner - The Blacksmith
 | 39 | The [NAME] | SEMI |  | 39 - 40 | The [NAME] - The Blacksmith
 | 40 | The [NAME] | SEMI |  | 40 - 41 | The Blacksmith - The Cobbler M4(2)
 | 41 | The Cobbler M4(2) | [NAME] |  | 41 | The Cobbler M4(2)
 | 42 | The Lymner | [NAME] |  | 42 | The Lymner
 | 43 | The Lymner | [NAME] |  | 43 | The Lymner
 | 44 | The Cutler | [NAME] |  | 44 | The Cutler
 | 45 | The Cobbler M4(2) | [NAME] |  | 45 | The Cobbler M4(2)
 | 46 | The Cutler | [NAME] |  | 46 | The Cutler
 | 47 | The Joiner | SEMI |  | 47 - 48 | The Joiner - The Joiner
 | 48 | The Joiner | SEMI |  | 48 - 49 | The Joiner - The Lymner
 | 49 | The Lymner | [NAME] |  | 49 | The Lymner
 | 50 | The Mason | [NAME] |  | 50 | The Mason
 | 51 | The Baxter | [NAME] |  | 51 | The Baxter
 | 52 | The Lymner | [NAME] |  | 52 | The Lymner
 | 53 | The Baxter | [NAME] |  | 53 | The Baxter
 | 54 | The Baxter | [NAME] |  | 54 | The Baxter
 | 55 | The Cutler | [NAME] |  | 55 | The Cutler
 | 56 | The Cutler | [NAME] |  | 56 | The Cutler
 | 57 | The Coppersmith M4(2) | [NAME] |  | 57 | The Coppersmith M4(2)
 | 58 | The Coppersmith M4(2) | [NAME] |  | 58 | The Coppersmith M4(2)
 | 59 | The Cobbler M4(2) | [NAME] |  | 59 | The Cobbler M4(2)
 | 60 | The Baxter | [NAME] |  | 60 | The Baxter
 | 61 | The Baxter | [NAME] |  | 61 | The Baxter
 | 62 | The [NAME] | Semi |  | 62 - 63 | The [NAME] - The Blacksmith
 | 63 | The [NAME] | Semi |  | 63 - 64 | The Blacksmith - The Baxter
 | 64 | The Baxter | [NAME] |  | 64 | The Baxter
 | 65 | The Coppersmith M4(2) | [NAME] |  | 65 | The Coppersmith M4(2)
 | 66 | The [NAME] | SEMI |  | 66 - 67 | The [NAME] - The Blacksmith
 | 67 | The [NAME] | Semi |  | 67 - 68 | The Blacksmith - The Baxter
 | 68 | The Baxter | DET |  | 68 | The Baxter
 | 69 | The [NAME] | SEMI |  | 69 - 70 | The [NAME] - The Blacksmith
 | 70 | The [NAME] | SEMI |  | 70 - 71 | The Blacksmith - The Thespian
 | 71 | The Thespian | SEMI |  | 71 - 72 | The Thespian - The Tailor
 | 72 | The Tailor | SEMI |  | 72 - 73 | The Tailor - The Coppersmith M4(2)
 | 73 | The Coppersmith M4(2) | [NAME] |  | 73 | The Coppersmith M4(2)
 | 74 | The Cobbler M4(2) | [NAME] |  | 74 | The Cobbler M4(2)
 | 75 | The Mason | [NAME] |  | 75 | The Mason
 | 76 | The Lymner | [NAME] |  | 76 | The Lymner
 | 77 | The Cobbler M4(2) | [NAME] |  | 77 | The Cobbler M4(2)
 | 78 | The Cobbler M4(2) | [NAME] |  | 78 | The Cobbler M4(2)
 | 79 | The Cutler | [NAME] |  | 79 | The Cutler
 | 80 | The Cutler | [NAME] |  | 80 | The Cutler
 | 81 | The Cutler | [NAME] |  | 81 | The Cutler
 | 82 | The Cobbler M4(2) | [NAME] |  | 82 | The Cobbler M4(2)
 | 83 | The Cutler | [NAME] |  | 83 | The Cutler
 | 84 | The Cobbler M4(2) | [NAME] |  | 84 | The Cobbler M4(2)
 | 85 | The Cutler | [NAME] |  | 85 | The Cutler
 | 86 | The Cutler | [NAME] |  | 86 | The Cutler
 | 87 | The Cobbler M4(2) | [NAME] |  | 87 | The Cobbler M4(2)
 | 88 | The Cobbler M4(2) | [NAME] |  | 88 | The Cobbler M4(2)
 | 89 | The Cutler | [NAME] |  | 89 | The Cutler
 | 90 | The Cutler | [NAME] |  | 90 | The Cutler
 | 91 | The Cobbler M4(2) | [NAME] |  | 91 | The Cobbler M4(2)
 | 92 | The Cobbler M4(2) | [NAME] |  | 92 | The Cobbler M4(2)
 | 93 | The Cutler | [NAME] |  | 93 | The Cutler
 | 94 | The Cutler | [NAME] |  | 94 | The Cutler
 | 95 | The Cutler | [NAME] |  | 95 | The Cutler
 | 96 | The Lymner | [NAME] |  | 96 | The Lymner
 | 97 | The Joiner | SEMI |  | 97 - 98 | The Joiner - The Joiner
 | 98 | The Joiner | SEMI |  | 98 - 99 | The Joiner - The Blacksmith
 | 99 | The [NAME] | Semi |  | 99 - 100 | The [NAME] - The Blacksmith
 | 100 | The [NAME] | Semi |  | 100 - 101 | The [NAME] - The Blacksmith
 | 101 | The [NAME] | Semi |  | 101 - 102 | The [NAME] - The Blacksmith
 | 102 | The [NAME] | Semi |  | 102 - 103 | The Blacksmith - The Joiner
 | 103 | The Joiner | Semi |  | 103 - 104 | The Joiner - The Joiner
 | 104 | The Joiner | Semi |  | 104 - 105 | The Joiner - The Cutler
 | 105 | The Cutler | [NAME] |  | 105 | The Cutler
 | 106 | The Cutler | [NAME] |  | 106 | The Cutler
 | 107 | The Cobbler M4(2) | [NAME] |  | 107 | The Cobbler M4(2)
 | 108 | The Mason | [NAME] |  | 108 | The Mason
 | 109 | The Tailor | Semi |  | 109 - 110 | The Tailor - The Tailor
 | 110 | The Tailor | Semi |  | 110 - 111 | The Tailor - The Mason
 | 111 | The Mason | DET |  | 111 | The Mason
 | 112 | The Mason | DET |  | 112 | The Mason
 | 113 | The Cutler | [NAME] |  | 113 | The Cutler
 | 114 | The Cutler | [NAME] |  | 114 | The Cutler
 | 115 | The Cobbler M4(2) | [NAME] |  | 115 | The Cobbler M4(2)
 | 116 | The Cobbler M4(2) | [NAME] |  | 116 | The Cobbler M4(2)
 | 117 | The [NAME] | Semi |  | 117 - 118 | The [NAME] - The Blacksmith
 | 118 | The [NAME] | Semi |  | 118 - 119 | The [NAME] - The Blacksmith
 | 119 | The [NAME] | Semi |  | 119 - 120 | The [NAME] - The Blacksmith
 | 120 | The [NAME] | Semi |  | 120 - 121 | The Blacksmith - The Baxter
 | 121 | The Baxter | DET |  | 121 | The Baxter
 | 122 | The Baxter | DET |  | 122 | The Baxter
 | 123 | The Coppersmith M4(2) | DET |  | 123 | The Coppersmith M4(2)
 | 124 | The Baxter | DET |  | 124 | The Baxter
 | 125 | The Baxter | DET |  | 125 | The Baxter
 | 126 | The [NAME] | Semi |  | 126 - 127 | The [NAME] - The Blacksmith
 | 127 | The [NAME] | Semi |  | 127 - 128 | The Blacksmith - The Tailor
 | 128 | The Tailor | Semi |  | 128 - 129 | The Tailor - The Thespian
 | 129 | The Thespian | Semi |  | 129 - 130 | The Thespian - The Cutler
 | 130 | The Cutler | [NAME] |  | 130 | The Cutler
 | 131 | The Cobbler M4(2) | [NAME] |  | 131 | The Cobbler M4(2)
 | 132 | The Lymner | [NAME] |  | 132 | The Lymner
 | 133 | The [NAME] | Semi |  | 133 - 134 | The [NAME] - The Blacksmith
 | 134 | The [NAME] | Semi |  | 134 - 135 | The Blacksmith - The Lymner
 | 135 | The Lymner | [NAME] |  | 135 | The Lymner
 | 136 | The Cobbler M4(2) | [NAME] |  | 136 | The Cobbler M4(2)
 | 137 | The Mason | [NAME] |  | 137 | The Mason
 | 138 | The Japonica SP | [NAME] |  | 138 | The Japonica SP
 | 139 | The Lymner | [NAME] |  | 139 | The Lymner
 | 140 | The Baxter | [NAME] |  | 140 | The Baxter
 | 141 | The Cobbler M4(2) | [NAME] |  | 141 | The Cobbler M4(2)
 | 142 | The Mason | [NAME] |  | 142 | The Mason
 | 143 | The Tailor | SEMI |  | 143 - 144 | The Tailor - The Tailor
 | 144 | The Tailor | SEMI |  | 144 - 145 | The Tailor - The Blacksmith
 | 145 | The [NAME] | SEMI |  | 145 - 146 | The [NAME] - The Blacksmith
 | 146 | The [NAME] | SEMI |  | 146 - 147 | The Blacksmith - The Joiner
 | 147 | The Joiner | SEMI |  | 147 - 148 | The Joiner - The Joiner
 | 148 | The Joiner | SEMI |  | 148 - 149 | The Joiner - The Cobbler M4(2)
 | 149 | The Cobbler M4(2) | [NAME] |  | 149 | The Cobbler M4(2)
 | 150 | The Cutler | [NAME] |  | 150 | The Cutler
 | 151 | The Cutler | [NAME] |  | 151 | The Cutler
 | 152 | The Joiner | SEMI |  | 152 - 153 | The Joiner - The Joiner
 | 153 | The Joiner | SEMI |  | 153 - 154 | The Joiner - The Mason
 | 154 | The Mason | [NAME] |  | 154 | The Mason
 | 155 | The Cutler | [NAME] |  | 155 | The Cutler
 | 156 | The Lymner | [NAME] |  | 156 | The Lymner
 | 157 | The Tailor | SEMI |  | 157 - 158 | The Tailor - The Thespian
 | 158 | The Thespian | SEMI |  | 158 - 159 | The Thespian - The Tailor
 | 159 | The Tailor | SEMI |  | 159 - 160 | The Tailor - The Tailor
 | 160 | The Tailor | SEMI |  | 160 - 161 | The Tailor - The Thespian
 | 161 | The Thespian | SEMI |  | 161 - 162 | The Thespian - The Tailor
 | 162 | The Tailor | SEMI |  | 162 - 163 | The Tailor - The Cobbler M4(2)
 | 163 | The Cobbler M4(2) | DET |  | 163 | The Cobbler M4(2)
 | 164 | The Cutler | DET |  | 164 | The Cutler
 | 165 | The Cutler | DET |  | 165 | The Cutler
 | 166 | The Cobbler M4(2) | DET |  | 166 | The Cobbler M4(2)
 | 167 | The Cutler | DET |  | 167 | The Cutler
 | 168 | The Cutler | DET |  | 168 | The Cutler
 | 169 | The Cobbler M4(2) | DET |  | 169 | The Cobbler M4(2)
 | 170 | The Joiner | SEMI |  | 170 - 171 | The Joiner - The Joiner
 | 171 | The Joiner | SEMI |  | 171 - 172 | The Joiner - The Coppersmith M4(2)
 | 172 | The Coppersmith M4(2) | DET |  | 172 | The Coppersmith M4(2)
 | 173 | The Cobbler M4(2) | DET |  | 173 | The Cobbler M4(2)
 | 174 | The Cobbler M4(2) | DET |  | 174 | The Cobbler M4(2)
 | 175 | The Baxter | DET |  | 175 | The Baxter
 | 176 | The [NAME] | SEMI |  | 176 - 177 | The [NAME] - The Blacksmith
 | 177 | The [NAME] | SEMI |  | 177 - 178 | The Blacksmith - The Lymner
 | 178 | The Lymner | DET |  | 178 | The Lymner
 | 179 | The Tailor | SEMI |  | 179 - 180 | The Tailor - The Tailor
 | 180 | The Tailor | SEMI |  | 180 - 181 | The Tailor - The Cobbler M4(2)
 | 181 | The Cobbler M4(2) | DET |  | 181 | The Cobbler M4(2)
 | 182 | The Mason | DET |  | 182 | The Mason
 | 183 | The Mason | DET |  | 183 | The Mason
 | 184 | The Cobbler M4(2) | DET |  | 184 | The Cobbler M4(2)
 | 185 | The Mason | DET |  | 185 | The Mason
 |  | Garages
 | 9 | Single Detached
 | 50 | Single Detached
 | 75 | Single Detached
 | 108 | Single Detached
 | 111 | Single Detached
 | 112 | Single Detached
 | 137&138 | Sales The Marketing Suite (Double shared detached)
 | 142 | Single Detached
 | 154 | Single Detached
 | 182 | Single Detached
 | 183 | Single Detached
 | 185 | Single Detached