Polyrhythm
New Member
- Joined
- Feb 11, 2008
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
Hi folks, I tried searching for an answer to this, but I couldn't figure out the correct wording.
Using the provided sample dataset, I'm trying to:
Using the provided sample dataset, I'm trying to:
- Find the first instance of the date that has a value greater than zero, and return that value.
- Find the last instance of the date that has a value greater than zero, and return that value.
| First and Last Values.xlsx | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | |||
| 1 | Year-Month | Values | Year-Month | First Value | Last Value | Last Value Minus First Value | |||||
| 2 | 2023-January | 0 | 2022-December | ||||||||
| 3 | 2023-January | 0 | 2023-January | 80,677 | 143,978 | 63,301 | <-- Expected Values | ||||
| 4 | 2023-January | 0 | 2023-February | ||||||||
| 5 | 2023-January | 0 | 2023-March | ||||||||
| 6 | 2023-January | 0 | |||||||||
| 7 | 2023-January | 0 | |||||||||
| 8 | 2023-January | 0 | |||||||||
| 9 | 2023-January | 0 | |||||||||
| 10 | 2023-January | 0 | |||||||||
| 11 | 2023-January | 0 | |||||||||
| 12 | 2023-January | 0 | |||||||||
| 13 | 2023-January | 0 | |||||||||
| 14 | 2023-January | 0 | |||||||||
| 15 | 2023-January | 0 | |||||||||
| 16 | 2023-January | 0 | |||||||||
| 17 | 2023-January | 0 | |||||||||
| 18 | 2023-January | 0 | |||||||||
| 19 | 2023-January | 0 | |||||||||
| 20 | 2023-January | 80,677 | |||||||||
| 21 | 2023-January | 80,677 | |||||||||
| 22 | 2023-January | 82,045 | |||||||||
| 23 | 2023-January | 83,111 | |||||||||
| 24 | 2023-January | 84,436 | |||||||||
| 25 | 2023-January | 84,966 | |||||||||
| 26 | 2023-January | 85,517 | |||||||||
| 27 | 2023-January | 87,034 | |||||||||
| 28 | 2023-January | 88,882 | |||||||||
| 29 | 2023-January | 90,166 | |||||||||
| 30 | 2023-January | 91,489 | |||||||||
| 31 | 2023-January | 93,671 | |||||||||
| 32 | 2023-January | 95,471 | |||||||||
| 33 | 2023-January | 97,393 | |||||||||
| 34 | 2023-January | 99,085 | |||||||||
| 35 | 2023-January | 100,910 | |||||||||
| 36 | 2023-January | 102,711 | |||||||||
| 37 | 2023-January | 104,631 | |||||||||
| 38 | 2023-January | 106,435 | |||||||||
| 39 | 2023-January | 108,332 | |||||||||
| 40 | 2023-January | 110,279 | |||||||||
| 41 | 2023-January | 111,740 | |||||||||
| 42 | 2023-January | 113,617 | |||||||||
| 43 | 2023-January | 113,696 | |||||||||
| 44 | 2023-January | 113,696 | |||||||||
| 45 | 2023-January | 113,696 | |||||||||
| 46 | 2023-January | 113,696 | |||||||||
| 47 | 2023-January | 113,696 | |||||||||
| 48 | 2023-January | 113,696 | |||||||||
| 49 | 2023-January | 113,696 | |||||||||
| 50 | 2023-January | 113,696 | |||||||||
| 51 | 2023-January | 113,696 | |||||||||
| 52 | 2023-January | 113,696 | |||||||||
| 53 | 2023-January | 113,696 | |||||||||
| 54 | 2023-January | 113,696 | |||||||||
| 55 | 2023-January | 113,696 | |||||||||
| 56 | 2023-January | 113,696 | |||||||||
| 57 | 2023-January | 113,696 | |||||||||
| 58 | 2023-January | 113,696 | |||||||||
| 59 | 2023-January | 113,696 | |||||||||
| 60 | 2023-January | 113,696 | |||||||||
| 61 | 2023-January | 113,696 | |||||||||
| 62 | 2023-January | 113,696 | |||||||||
| 63 | 2023-January | 113,696 | |||||||||
| 64 | 2023-January | 113,696 | |||||||||
| 65 | 2023-January | 113,696 | |||||||||
| 66 | 2023-January | 113,696 | |||||||||
| 67 | 2023-January | 113,696 | |||||||||
| 68 | 2023-January | 113,696 | |||||||||
| 69 | 2023-January | 113,696 | |||||||||
| 70 | 2023-January | 113,696 | |||||||||
| 71 | 2023-January | 113,696 | |||||||||
| 72 | 2023-January | 113,696 | |||||||||
| 73 | 2023-January | 113,696 | |||||||||
| 74 | 2023-January | 113,696 | |||||||||
| 75 | 2023-January | 113,696 | |||||||||
| 76 | 2023-January | 113,696 | |||||||||
| 77 | 2023-January | 113,696 | |||||||||
| 78 | 2023-January | 113,696 | |||||||||
| 79 | 2023-January | 113,696 | |||||||||
| 80 | 2023-January | 113,696 | |||||||||
| 81 | 2023-January | 113,696 | |||||||||
| 82 | 2023-January | 113,696 | |||||||||
| 83 | 2023-January | 113,696 | |||||||||
| 84 | 2023-January | 113,696 | |||||||||
| 85 | 2023-January | 113,696 | |||||||||
| 86 | 2023-January | 113,696 | |||||||||
| 87 | 2023-January | 113,696 | |||||||||
| 88 | 2023-January | 113,696 | |||||||||
| 89 | 2023-January | 113,696 | |||||||||
| 90 | 2023-January | 113,696 | |||||||||
| 91 | 2023-January | 113,696 | |||||||||
| 92 | 2023-January | 113,696 | |||||||||
| 93 | 2023-January | 113,696 | |||||||||
| 94 | 2023-January | 113,696 | |||||||||
| 95 | 2023-January | 113,696 | |||||||||
| 96 | 2023-January | 113,696 | |||||||||
| 97 | 2023-January | 113,696 | |||||||||
| 98 | 2023-January | 113,696 | |||||||||
| 99 | 2023-January | 113,696 | |||||||||
| 100 | 2023-January | 113,696 | |||||||||
| 101 | 2023-January | 113,696 | |||||||||
| 102 | 2023-January | 113,696 | |||||||||
| 103 | 2023-January | 113,696 | |||||||||
| 104 | 2023-January | 113,696 | |||||||||
| 105 | 2023-January | 113,696 | |||||||||
| 106 | 2023-January | 113,696 | |||||||||
| 107 | 2023-January | 113,696 | |||||||||
| 108 | 2023-January | 113,696 | |||||||||
| 109 | 2023-January | 113,696 | |||||||||
| 110 | 2023-January | 113,696 | |||||||||
| 111 | 2023-January | 113,696 | |||||||||
| 112 | 2023-January | 113,696 | |||||||||
| 113 | 2023-January | 113,696 | |||||||||
| 114 | 2023-January | 113,696 | |||||||||
| 115 | 2023-January | 113,696 | |||||||||
| 116 | 2023-January | 113,696 | |||||||||
| 117 | 2023-January | 113,696 | |||||||||
| 118 | 2023-January | 113,696 | |||||||||
| 119 | 2023-January | 113,696 | |||||||||
| 120 | 2023-January | 113,696 | |||||||||
| 121 | 2023-January | 113,696 | |||||||||
| 122 | 2023-January | 113,696 | |||||||||
| 123 | 2023-January | 113,696 | |||||||||
| 124 | 2023-January | 113,696 | |||||||||
| 125 | 2023-January | 113,696 | |||||||||
| 126 | 2023-January | 113,696 | |||||||||
| 127 | 2023-January | 113,696 | |||||||||
| 128 | 2023-January | 113,696 | |||||||||
| 129 | 2023-January | 113,696 | |||||||||
| 130 | 2023-January | 113,696 | |||||||||
| 131 | 2023-January | 113,696 | |||||||||
| 132 | 2023-January | 113,696 | |||||||||
| 133 | 2023-January | 113,696 | |||||||||
| 134 | 2023-January | 113,696 | |||||||||
| 135 | 2023-January | 113,696 | |||||||||
| 136 | 2023-January | 113,696 | |||||||||
| 137 | 2023-January | 113,696 | |||||||||
| 138 | 2023-January | 113,696 | |||||||||
| 139 | 2023-January | 113,696 | |||||||||
| 140 | 2023-January | 113,696 | |||||||||
| 141 | 2023-January | 113,696 | |||||||||
| 142 | 2023-January | 113,696 | |||||||||
| 143 | 2023-January | 113,696 | |||||||||
| 144 | 2023-January | 113,696 | |||||||||
| 145 | 2023-January | 113,696 | |||||||||
| 146 | 2023-January | 113,696 | |||||||||
| 147 | 2023-January | 113,696 | |||||||||
| 148 | 2023-January | 113,696 | |||||||||
| 149 | 2023-January | 113,696 | |||||||||
| 150 | 2023-January | 113,696 | |||||||||
| 151 | 2023-January | 113,696 | |||||||||
| 152 | 2023-January | 113,696 | |||||||||
| 153 | 2023-January | 113,696 | |||||||||
| 154 | 2023-January | 113,696 | |||||||||
| 155 | 2023-January | 113,696 | |||||||||
| 156 | 2023-January | 113,696 | |||||||||
| 157 | 2023-January | 113,696 | |||||||||
| 158 | 2023-January | 113,696 | |||||||||
| 159 | 2023-January | 113,696 | |||||||||
| 160 | 2023-January | 113,696 | |||||||||
| 161 | 2023-January | 113,696 | |||||||||
| 162 | 2023-January | 113,696 | |||||||||
| 163 | 2023-January | 113,696 | |||||||||
| 164 | 2023-January | 113,696 | |||||||||
| 165 | 2023-January | 113,696 | |||||||||
| 166 | 2023-January | 113,696 | |||||||||
| 167 | 2023-January | 113,696 | |||||||||
| 168 | 2023-January | 113,696 | |||||||||
| 169 | 2023-January | 113,696 | |||||||||
| 170 | 2023-January | 113,696 | |||||||||
| 171 | 2023-January | 113,696 | |||||||||
| 172 | 2023-January | 113,696 | |||||||||
| 173 | 2023-January | 113,696 | |||||||||
| 174 | 2023-January | 113,696 | |||||||||
| 175 | 2023-January | 113,696 | |||||||||
| 176 | 2023-January | 113,696 | |||||||||
| 177 | 2023-January | 113,696 | |||||||||
| 178 | 2023-January | 113,696 | |||||||||
| 179 | 2023-January | 113,696 | |||||||||
| 180 | 2023-January | 113,696 | |||||||||
| 181 | 2023-January | 113,696 | |||||||||
| 182 | 2023-January | 113,696 | |||||||||
| 183 | 2023-January | 113,696 | |||||||||
| 184 | 2023-January | 113,696 | |||||||||
| 185 | 2023-January | 113,696 | |||||||||
| 186 | 2023-January | 113,696 | |||||||||
| 187 | 2023-January | 113,696 | |||||||||
| 188 | 2023-January | 113,696 | |||||||||
| 189 | 2023-January | 113,696 | |||||||||
| 190 | 2023-January | 113,696 | |||||||||
| 191 | 2023-January | 113,696 | |||||||||
| 192 | 2023-January | 113,696 | |||||||||
| 193 | 2023-January | 113,696 | |||||||||
| 194 | 2023-January | 113,696 | |||||||||
| 195 | 2023-January | 113,696 | |||||||||
| 196 | 2023-January | 113,696 | |||||||||
| 197 | 2023-January | 113,696 | |||||||||
| 198 | 2023-January | 113,696 | |||||||||
| 199 | 2023-January | 113,696 | |||||||||
| 200 | 2023-January | 113,696 | |||||||||
| 201 | 2023-January | 113,696 | |||||||||
| 202 | 2023-January | 113,696 | |||||||||
| 203 | 2023-January | 113,696 | |||||||||
| 204 | 2023-January | 113,696 | |||||||||
| 205 | 2023-January | 113,696 | |||||||||
| 206 | 2023-January | 113,696 | |||||||||
| 207 | 2023-January | 113,696 | |||||||||
| 208 | 2023-January | 113,696 | |||||||||
| 209 | 2023-January | 113,696 | |||||||||
| 210 | 2023-January | 113,696 | |||||||||
| 211 | 2023-January | 113,696 | |||||||||
| 212 | 2023-January | 113,696 | |||||||||
| 213 | 2023-January | 113,696 | |||||||||
| 214 | 2023-January | 113,696 | |||||||||
| 215 | 2023-January | 113,696 | |||||||||
| 216 | 2023-January | 113,696 | |||||||||
| 217 | 2023-January | 113,696 | |||||||||
| 218 | 2023-January | 113,696 | |||||||||
| 219 | 2023-January | 113,696 | |||||||||
| 220 | 2023-January | 113,696 | |||||||||
| 221 | 2023-January | 113,696 | |||||||||
| 222 | 2023-January | 113,696 | |||||||||
| 223 | 2023-January | 113,696 | |||||||||
| 224 | 2023-January | 113,696 | |||||||||
| 225 | 2023-January | 113,696 | |||||||||
| 226 | 2023-January | 113,696 | |||||||||
| 227 | 2023-January | 113,696 | |||||||||
| 228 | 2023-January | 113,696 | |||||||||
| 229 | 2023-January | 113,696 | |||||||||
| 230 | 2023-January | 113,696 | |||||||||
| 231 | 2023-January | 113,696 | |||||||||
| 232 | 2023-January | 113,696 | |||||||||
| 233 | 2023-January | 113,696 | |||||||||
| 234 | 2023-January | 113,696 | |||||||||
| 235 | 2023-January | 113,696 | |||||||||
| 236 | 2023-January | 113,696 | |||||||||
| 237 | 2023-January | 113,696 | |||||||||
| 238 | 2023-January | 113,696 | |||||||||
| 239 | 2023-January | 113,696 | |||||||||
| 240 | 2023-January | 113,696 | |||||||||
| 241 | 2023-January | 0 | |||||||||
| 242 | 2023-January | 0 | |||||||||
| 243 | 2023-January | 0 | |||||||||
| 244 | 2023-January | 0 | |||||||||
| 245 | 2023-January | 0 | |||||||||
| 246 | 2023-January | 0 | |||||||||
| 247 | 2023-January | 0 | |||||||||
| 248 | 2023-January | 0 | |||||||||
| 249 | 2023-January | 0 | |||||||||
| 250 | 2023-January | 0 | |||||||||
| 251 | 2023-January | 0 | |||||||||
| 252 | 2023-January | 0 | |||||||||
| 253 | 2023-January | 0 | |||||||||
| 254 | 2023-January | 0 | |||||||||
| 255 | 2023-January | 0 | |||||||||
| 256 | 2023-January | 0 | |||||||||
| 257 | 2023-January | 0 | |||||||||
| 258 | 2023-January | 0 | |||||||||
| 259 | 2023-January | 0 | |||||||||
| 260 | 2023-January | 0 | |||||||||
| 261 | 2023-January | 0 | |||||||||
| 262 | 2023-January | 0 | |||||||||
| 263 | 2023-January | 0 | |||||||||
| 264 | 2023-January | 0 | |||||||||
| 265 | 2023-January | 0 | |||||||||
| 266 | 2023-January | 0 | |||||||||
| 267 | 2023-January | 0 | |||||||||
| 268 | 2023-January | 0 | |||||||||
| 269 | 2023-January | 0 | |||||||||
| 270 | 2023-January | 0 | |||||||||
| 271 | 2023-January | 0 | |||||||||
| 272 | 2023-January | 0 | |||||||||
| 273 | 2023-January | 0 | |||||||||
| 274 | 2023-January | 0 | |||||||||
| 275 | 2023-January | 0 | |||||||||
| 276 | 2023-January | 0 | |||||||||
| 277 | 2023-January | 0 | |||||||||
| 278 | 2023-January | 0 | |||||||||
| 279 | 2023-January | 0 | |||||||||
| 280 | 2023-January | 0 | |||||||||
| 281 | 2023-January | 0 | |||||||||
| 282 | 2023-January | 0 | |||||||||
| 283 | 2023-January | 0 | |||||||||
| 284 | 2023-January | 0 | |||||||||
| 285 | 2023-January | 0 | |||||||||
| 286 | 2023-January | 0 | |||||||||
| 287 | 2023-January | 0 | |||||||||
| 288 | 2023-January | 0 | |||||||||
| 289 | 2023-January | 0 | |||||||||
| 290 | 2023-January | 0 | |||||||||
| 291 | 2023-January | 0 | |||||||||
| 292 | 2023-January | 0 | |||||||||
| 293 | 2023-January | 0 | |||||||||
| 294 | 2023-January | 0 | |||||||||
| 295 | 2023-January | 0 | |||||||||
| 296 | 2023-January | 0 | |||||||||
| 297 | 2023-January | 0 | |||||||||
| 298 | 2023-January | 0 | |||||||||
| 299 | 2023-January | 0 | |||||||||
| 300 | 2023-January | 0 | |||||||||
| 301 | 2023-January | 0 | |||||||||
| 302 | 2023-January | 0 | |||||||||
| 303 | 2023-January | 0 | |||||||||
| 304 | 2023-January | 0 | |||||||||
| 305 | 2023-January | 0 | |||||||||
| 306 | 2023-January | 0 | |||||||||
| 307 | 2023-January | 0 | |||||||||
| 308 | 2023-January | 143,978 | |||||||||
| 309 | 2023-January | 0 | |||||||||
| 310 | 2023-January | 0 | |||||||||
| 311 | 2023-January | 0 | |||||||||
| 312 | 2023-January | 0 | |||||||||
| 313 | 2023-January | 0 | |||||||||
| 314 | 2023-January | 0 | |||||||||
| 315 | 2023-January | 0 | |||||||||
| 316 | 2023-January | 0 | |||||||||
| 317 | 2023-January | 0 | |||||||||
| 318 | 2023-January | 0 | |||||||||
| 319 | 2023-January | 0 | |||||||||
| 320 | 2023-January | 0 | |||||||||
| 321 | 2023-January | 0 | |||||||||
| 322 | 2023-January | 0 | |||||||||
| 323 | 2023-January | 0 | |||||||||
| 324 | 2023-January | 0 | |||||||||
| 325 | 2023-January | 0 | |||||||||
| 326 | 2023-January | 0 | |||||||||
| 327 | 2023-January | 0 | |||||||||
| 328 | 2023-January | 0 | |||||||||
| 329 | 2023-January | 0 | |||||||||
Sheet2 | |||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G3 | G3 | =F3-E3 |
