I have two sheets:
8km Points
and TT
8km points:
on my TT sheet I have:
for Points i have the following formula: =IFERROR(INDEX(('8km Points'!$C$4:$L$234),MATCH(N3,'8km Points'!$B$4:$B$234,1),MATCH(K3,'8km Points'!$C$3:$L$3,0)),0)
the results are giving me the points for the time over the 10sec and not under the 10sec so the times should be taken as
0:35:50 instead of 0:35:40
0:52:20 instead of 0:52:10
0:29:00 instead of 0:28:50
0:50:40 instead of 0:50:30
0:35:50 instead of 0:35:40
1:03:10 instead of 1:03:00
0:48:50 instead of 0:48:40
0:48:50 instead of 0:48:40
how do I correct my formula so that it gives me the correct points based on the time?
8km Points
and TT
8km points:
Age Range | |||||||||||
J | S | 35-39 | 40-44 | 45-49 | 50-54 | 55-59 | 60-64 | 65-69 | 70+ | ||
Time Range | 00:25:50 | 267 | 267 | 277 | 287 | 297 | 307 | 317 | 327 | 337 | 347 |
00:26:00 | 266 | 266 | 276 | 286 | 296 | 306 | 316 | 326 | 336 | 346 | |
00:26:10 | 265 | 265 | 275 | 285 | 295 | 305 | 315 | 325 | 335 | 345 | |
00:26:20 | 264 | 264 | 274 | 284 | 294 | 304 | 314 | 324 | 334 | 344 | |
00:26:30 | 263 | 263 | 273 | 283 | 293 | 303 | 313 | 323 | 333 | 343 | |
00:26:40 | 262 | 262 | 272 | 282 | 292 | 302 | 312 | 322 | 332 | 342 | |
00:26:50 | 261 | 261 | 271 | 281 | 291 | 301 | 311 | 321 | 331 | 341 | |
00:27:00 | 260 | 260 | 270 | 280 | 290 | 300 | 310 | 320 | 330 | 340 | |
00:27:10 | 259 | 259 | 269 | 279 | 289 | 299 | 309 | 319 | 329 | 339 | |
00:27:20 | 258 | 258 | 268 | 278 | 288 | 298 | 308 | 318 | 328 | 338 | |
00:27:30 | 257 | 257 | 267 | 277 | 287 | 297 | 307 | 317 | 327 | 337 | |
00:27:40 | 256 | 256 | 266 | 276 | 286 | 296 | 306 | 316 | 326 | 336 | |
00:27:50 | 255 | 255 | 265 | 275 | 285 | 295 | 305 | 315 | 325 | 335 | |
00:28:00 | 254 | 254 | 264 | 274 | 284 | 294 | 304 | 314 | 324 | 334 | |
00:28:10 | 253 | 253 | 263 | 273 | 283 | 293 | 303 | 313 | 323 | 333 | |
00:28:20 | 252 | 252 | 262 | 272 | 282 | 292 | 302 | 312 | 322 | 332 | |
00:28:30 | 251 | 251 | 261 | 271 | 281 | 291 | 301 | 311 | 321 | 331 | |
00:28:40 | 250 | 250 | 260 | 270 | 280 | 290 | 300 | 310 | 320 | 330 | |
00:28:50 | 249 | 249 | 259 | 269 | 279 | 289 | 299 | 309 | 319 | 329 | |
00:29:00 | 248 | 248 | 258 | 268 | 278 | 288 | 298 | 308 | 318 | 328 | |
00:29:10 | 247 | 247 | 257 | 267 | 277 | 287 | 297 | 307 | 317 | 327 | |
00:29:20 | 246 | 246 | 256 | 266 | 276 | 286 | 296 | 306 | 316 | 326 | |
00:29:30 | 245 | 245 | 255 | 265 | 275 | 285 | 295 | 305 | 315 | 325 | |
00:29:40 | 244 | 244 | 254 | 264 | 274 | 284 | 294 | 304 | 314 | 324 | |
00:29:50 | 243 | 243 | 253 | 263 | 273 | 283 | 293 | 303 | 313 | 323 | |
00:30:00 | 242 | 242 | 252 | 262 | 272 | 282 | 292 | 302 | 312 | 322 | |
00:30:10 | 241 | 241 | 251 | 261 | 271 | 281 | 291 | 301 | 311 | 321 | |
00:30:20 | 240 | 240 | 250 | 260 | 270 | 280 | 290 | 300 | 310 | 320 | |
00:30:30 | 239 | 239 | 249 | 259 | 269 | 279 | 289 | 299 | 309 | 319 | |
00:30:40 | 238 | 238 | 248 | 258 | 268 | 278 | 288 | 298 | 308 | 318 | |
00:30:50 | 237 | 237 | 247 | 257 | 267 | 277 | 287 | 297 | 307 | 317 | |
00:31:00 | 236 | 236 | 246 | 256 | 266 | 276 | 286 | 296 | 306 | 316 | |
00:31:10 | 235 | 235 | 245 | 255 | 265 | 275 | 285 | 295 | 305 | 315 | |
00:31:20 | 234 | 234 | 244 | 254 | 264 | 274 | 284 | 294 | 304 | 314 | |
00:31:30 | 233 | 233 | 243 | 253 | 263 | 273 | 283 | 293 | 303 | 313 | |
00:31:40 | 232 | 232 | 242 | 252 | 262 | 272 | 282 | 292 | 302 | 312 | |
00:31:50 | 231 | 231 | 241 | 251 | 261 | 271 | 281 | 291 | 301 | 311 | |
00:32:00 | 230 | 230 | 240 | 250 | 260 | 270 | 280 | 290 | 300 | 310 | |
00:32:10 | 229 | 229 | 239 | 249 | 259 | 269 | 279 | 289 | 299 | 309 | |
00:32:20 | 228 | 228 | 238 | 248 | 258 | 268 | 278 | 288 | 298 | 308 | |
00:32:30 | 227 | 227 | 237 | 247 | 257 | 267 | 277 | 287 | 297 | 307 | |
00:32:40 | 226 | 226 | 236 | 246 | 256 | 266 | 276 | 286 | 296 | 306 | |
00:32:50 | 225 | 225 | 235 | 245 | 255 | 265 | 275 | 285 | 295 | 305 | |
00:33:00 | 224 | 224 | 234 | 244 | 254 | 264 | 274 | 284 | 294 | 304 | |
00:33:10 | 223 | 223 | 233 | 243 | 253 | 263 | 273 | 283 | 293 | 303 | |
00:33:20 | 222 | 222 | 232 | 242 | 252 | 262 | 272 | 282 | 292 | 302 | |
00:33:30 | 221 | 221 | 231 | 241 | 251 | 261 | 271 | 281 | 291 | 301 | |
00:33:40 | 220 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290 | 300 | |
00:33:50 | 219 | 219 | 229 | 239 | 249 | 259 | 269 | 279 | 289 | 299 | |
00:34:00 | 218 | 218 | 228 | 238 | 248 | 258 | 268 | 278 | 288 | 298 | |
00:34:10 | 217 | 217 | 227 | 237 | 247 | 257 | 267 | 277 | 287 | 297 | |
00:34:20 | 216 | 216 | 226 | 236 | 246 | 256 | 266 | 276 | 286 | 296 | |
00:34:30 | 215 | 215 | 225 | 235 | 245 | 255 | 265 | 275 | 285 | 295 | |
00:34:40 | 214 | 214 | 224 | 234 | 244 | 254 | 264 | 274 | 284 | 294 | |
00:34:50 | 213 | 213 | 223 | 233 | 243 | 253 | 263 | 273 | 283 | 293 | |
00:35:00 | 212 | 212 | 222 | 232 | 242 | 252 | 262 | 272 | 282 | 292 | |
00:35:10 | 211 | 211 | 221 | 231 | 241 | 251 | 261 | 271 | 281 | 291 | |
00:35:20 | 210 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 290 | |
00:35:30 | 209 | 209 | 219 | 229 | 239 | 249 | 259 | 269 | 279 | 289 | |
00:35:40 | 208 | 208 | 218 | 228 | 238 | 248 | 258 | 268 | 278 | 288 | |
00:35:50 | 207 | 207 | 217 | 227 | 237 | 247 | 257 | 267 | 277 | 287 | |
00:36:00 | 206 | 206 | 216 | 226 | 236 | 246 | 256 | 266 | 276 | 286 | |
00:36:10 | 205 | 205 | 215 | 225 | 235 | 245 | 255 | 265 | 275 | 285 | |
00:36:20 | 204 | 204 | 214 | 224 | 234 | 244 | 254 | 264 | 274 | 284 | |
00:36:30 | 203 | 203 | 213 | 223 | 233 | 243 | 253 | 263 | 273 | 283 | |
00:36:40 | 202 | 202 | 212 | 222 | 232 | 242 | 252 | 262 | 272 | 282 | |
00:36:50 | 201 | 201 | 211 | 221 | 231 | 241 | 251 | 261 | 271 | 281 | |
00:37:00 | 200 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | |
00:37:10 | 199 | 199 | 209 | 219 | 229 | 239 | 249 | 259 | 269 | 279 | |
00:37:20 | 198 | 198 | 208 | 218 | 228 | 238 | 248 | 258 | 268 | 278 | |
00:37:30 | 197 | 197 | 207 | 217 | 227 | 237 | 247 | 257 | 267 | 277 | |
00:37:40 | 196 | 196 | 206 | 216 | 226 | 236 | 246 | 256 | 266 | 276 | |
00:37:50 | 195 | 195 | 205 | 215 | 225 | 235 | 245 | 255 | 265 | 275 | |
00:38:00 | 194 | 194 | 204 | 214 | 224 | 234 | 244 | 254 | 264 | 274 | |
00:38:10 | 193 | 193 | 203 | 213 | 223 | 233 | 243 | 253 | 263 | 273 | |
00:38:20 | 192 | 192 | 202 | 212 | 222 | 232 | 242 | 252 | 262 | 272 | |
00:38:30 | 191 | 191 | 201 | 211 | 221 | 231 | 241 | 251 | 261 | 271 | |
00:38:40 | 190 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | |
00:38:50 | 189 | 189 | 199 | 209 | 219 | 229 | 239 | 249 | 259 | 269 | |
00:39:00 | 188 | 188 | 198 | 208 | 218 | 228 | 238 | 248 | 258 | 268 | |
00:39:10 | 187 | 187 | 197 | 207 | 217 | 227 | 237 | 247 | 257 | 267 | |
00:39:20 | 186 | 186 | 196 | 206 | 216 | 226 | 236 | 246 | 256 | 266 | |
00:39:30 | 185 | 185 | 195 | 205 | 215 | 225 | 235 | 245 | 255 | 265 | |
00:39:40 | 184 | 184 | 194 | 204 | 214 | 224 | 234 | 244 | 254 | 264 | |
00:39:50 | 183 | 183 | 193 | 203 | 213 | 223 | 233 | 243 | 253 | 263 | |
00:40:00 | 182 | 182 | 192 | 202 | 212 | 222 | 232 | 242 | 252 | 262 | |
00:40:10 | 181 | 181 | 191 | 201 | 211 | 221 | 231 | 241 | 251 | 261 | |
00:40:20 | 180 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | 260 | |
00:40:30 | 179 | 179 | 189 | 199 | 209 | 219 | 229 | 239 | 249 | 259 | |
00:40:40 | 178 | 178 | 188 | 198 | 208 | 218 | 228 | 238 | 248 | 258 | |
00:40:50 | 177 | 177 | 187 | 197 | 207 | 217 | 227 | 237 | 247 | 257 | |
00:41:00 | 176 | 176 | 186 | 196 | 206 | 216 | 226 | 236 | 246 | 256 | |
00:41:10 | 175 | 175 | 185 | 195 | 205 | 215 | 225 | 235 | 245 | 255 | |
00:41:20 | 174 | 174 | 184 | 194 | 204 | 214 | 224 | 234 | 244 | 254 | |
00:41:30 | 173 | 173 | 183 | 193 | 203 | 213 | 223 | 233 | 243 | 253 | |
00:41:40 | 172 | 172 | 182 | 192 | 202 | 212 | 222 | 232 | 242 | 252 | |
00:41:50 | 171 | 171 | 181 | 191 | 201 | 211 | 221 | 231 | 241 | 251 | |
00:42:00 | 170 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | 250 | |
00:42:10 | 169 | 169 | 179 | 189 | 199 | 209 | 219 | 229 | 239 | 249 | |
00:42:20 | 168 | 168 | 178 | 188 | 198 | 208 | 218 | 228 | 238 | 248 | |
00:42:30 | 167 | 167 | 177 | 187 | 197 | 207 | 217 | 227 | 237 | 247 | |
00:42:40 | 166 | 166 | 176 | 186 | 196 | 206 | 216 | 226 | 236 | 246 | |
00:42:50 | 165 | 165 | 175 | 185 | 195 | 205 | 215 | 225 | 235 | 245 | |
00:43:00 | 164 | 164 | 174 | 184 | 194 | 204 | 214 | 224 | 234 | 244 | |
00:43:10 | 163 | 163 | 173 | 183 | 193 | 203 | 213 | 223 | 233 | 243 | |
00:43:20 | 162 | 162 | 172 | 182 | 192 | 202 | 212 | 222 | 232 | 242 | |
00:43:30 | 161 | 161 | 171 | 181 | 191 | 201 | 211 | 221 | 231 | 241 | |
00:43:40 | 160 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | 240 | |
00:43:50 | 159 | 159 | 169 | 179 | 189 | 199 | 209 | 219 | 229 | 239 | |
00:44:00 | 158 | 158 | 168 | 178 | 188 | 198 | 208 | 218 | 228 | 238 | |
00:44:10 | 157 | 157 | 167 | 177 | 187 | 197 | 207 | 217 | 227 | 237 | |
00:44:20 | 156 | 156 | 166 | 176 | 186 | 196 | 206 | 216 | 226 | 236 | |
00:44:30 | 155 | 155 | 165 | 175 | 185 | 195 | 205 | 215 | 225 | 235 | |
00:44:40 | 154 | 154 | 164 | 174 | 184 | 194 | 204 | 214 | 224 | 234 | |
00:44:50 | 153 | 153 | 163 | 173 | 183 | 193 | 203 | 213 | 223 | 233 | |
00:45:00 | 152 | 152 | 162 | 172 | 182 | 192 | 202 | 212 | 222 | 232 | |
00:45:10 | 151 | 151 | 161 | 171 | 181 | 191 | 201 | 211 | 221 | 231 | |
00:45:20 | 150 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | 230 | |
00:45:30 | 149 | 149 | 159 | 169 | 179 | 189 | 199 | 209 | 219 | 229 | |
00:45:40 | 148 | 148 | 158 | 168 | 178 | 188 | 198 | 208 | 218 | 228 | |
00:45:50 | 147 | 147 | 157 | 167 | 177 | 187 | 197 | 207 | 217 | 227 | |
00:46:00 | 146 | 146 | 156 | 166 | 176 | 186 | 196 | 206 | 216 | 226 | |
00:46:10 | 145 | 145 | 155 | 165 | 175 | 185 | 195 | 205 | 215 | 225 | |
00:46:20 | 144 | 144 | 154 | 164 | 174 | 184 | 194 | 204 | 214 | 224 | |
00:46:30 | 143 | 143 | 153 | 163 | 173 | 183 | 193 | 203 | 213 | 223 | |
00:46:40 | 142 | 142 | 152 | 162 | 172 | 182 | 192 | 202 | 212 | 222 | |
00:46:50 | 141 | 141 | 151 | 161 | 171 | 181 | 191 | 201 | 211 | 221 | |
00:47:00 | 140 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | 220 | |
00:47:10 | 139 | 139 | 149 | 159 | 169 | 179 | 189 | 199 | 209 | 219 | |
00:47:20 | 138 | 138 | 148 | 158 | 168 | 178 | 188 | 198 | 208 | 218 | |
00:47:30 | 137 | 137 | 147 | 157 | 167 | 177 | 187 | 197 | 207 | 217 | |
00:47:40 | 136 | 136 | 146 | 156 | 166 | 176 | 186 | 196 | 206 | 216 | |
00:47:50 | 135 | 135 | 145 | 155 | 165 | 175 | 185 | 195 | 205 | 215 | |
00:48:00 | 134 | 134 | 144 | 154 | 164 | 174 | 184 | 194 | 204 | 214 | |
00:48:10 | 133 | 133 | 143 | 153 | 163 | 173 | 183 | 193 | 203 | 213 | |
00:48:20 | 132 | 132 | 142 | 152 | 162 | 172 | 182 | 192 | 202 | 212 | |
00:48:30 | 131 | 131 | 141 | 151 | 161 | 171 | 181 | 191 | 201 | 211 | |
00:48:40 | 130 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | 210 | |
00:48:50 | 129 | 129 | 139 | 149 | 159 | 169 | 179 | 189 | 199 | 209 | |
00:49:00 | 128 | 128 | 138 | 148 | 158 | 168 | 178 | 188 | 198 | 208 | |
00:49:10 | 127 | 127 | 137 | 147 | 157 | 167 | 177 | 187 | 197 | 207 | |
00:49:20 | 126 | 126 | 136 | 146 | 156 | 166 | 176 | 186 | 196 | 206 | |
00:49:30 | 125 | 125 | 135 | 145 | 155 | 165 | 175 | 185 | 195 | 205 | |
00:49:40 | 124 | 124 | 134 | 144 | 154 | 164 | 174 | 184 | 194 | 204 | |
00:49:50 | 123 | 123 | 133 | 143 | 153 | 163 | 173 | 183 | 193 | 203 | |
00:50:00 | 122 | 122 | 132 | 142 | 152 | 162 | 172 | 182 | 192 | 202 | |
00:50:10 | 121 | 121 | 131 | 141 | 151 | 161 | 171 | 181 | 191 | 201 | |
00:50:20 | 120 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | 200 | |
00:50:30 | 119 | 119 | 129 | 139 | 149 | 159 | 169 | 179 | 189 | 199 | |
00:50:40 | 118 | 118 | 128 | 138 | 148 | 158 | 168 | 178 | 188 | 198 | |
00:50:50 | 117 | 117 | 127 | 137 | 147 | 157 | 167 | 177 | 187 | 197 | |
00:51:00 | 116 | 116 | 126 | 136 | 146 | 156 | 166 | 176 | 186 | 196 | |
00:51:10 | 115 | 115 | 125 | 135 | 145 | 155 | 165 | 175 | 185 | 195 | |
00:51:20 | 114 | 114 | 124 | 134 | 144 | 154 | 164 | 174 | 184 | 194 | |
00:51:30 | 113 | 113 | 123 | 133 | 143 | 153 | 163 | 173 | 183 | 193 | |
00:51:40 | 112 | 112 | 122 | 132 | 142 | 152 | 162 | 172 | 182 | 192 | |
00:51:50 | 111 | 111 | 121 | 131 | 141 | 151 | 161 | 171 | 181 | 191 | |
00:52:00 | 110 | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | 190 | |
00:52:10 | 109 | 109 | 119 | 129 | 139 | 149 | 159 | 169 | 179 | 189 | |
00:52:20 | 108 | 108 | 118 | 128 | 138 | 148 | 158 | 168 | 178 | 188 | |
00:52:30 | 107 | 107 | 117 | 127 | 137 | 147 | 157 | 167 | 177 | 187 | |
00:52:40 | 106 | 106 | 116 | 126 | 136 | 146 | 156 | 166 | 176 | 186 | |
00:52:50 | 105 | 105 | 115 | 125 | 135 | 145 | 155 | 165 | 175 | 185 | |
00:53:00 | 104 | 104 | 114 | 124 | 134 | 144 | 154 | 164 | 174 | 184 | |
00:53:10 | 103 | 103 | 113 | 123 | 133 | 143 | 153 | 163 | 173 | 183 | |
00:53:20 | 102 | 102 | 112 | 122 | 132 | 142 | 152 | 162 | 172 | 182 | |
00:53:30 | 101 | 101 | 111 | 121 | 131 | 141 | 151 | 161 | 171 | 181 | |
00:53:40 | 100 | 100 | 110 | 120 | 130 | 140 | 150 | 160 | 170 | 180 | |
00:53:50 | 99 | 99 | 109 | 119 | 129 | 139 | 149 | 159 | 169 | 179 | |
00:54:00 | 98 | 98 | 108 | 118 | 128 | 138 | 148 | 158 | 168 | 178 | |
00:54:10 | 97 | 97 | 107 | 117 | 127 | 137 | 147 | 157 | 167 | 177 | |
00:54:20 | 96 | 96 | 106 | 116 | 126 | 136 | 146 | 156 | 166 | 176 | |
00:54:30 | 95 | 95 | 105 | 115 | 125 | 135 | 145 | 155 | 165 | 175 | |
00:54:40 | 94 | 94 | 104 | 114 | 124 | 134 | 144 | 154 | 164 | 174 | |
00:54:50 | 93 | 93 | 103 | 113 | 123 | 133 | 143 | 153 | 163 | 173 | |
00:55:00 | 92 | 92 | 102 | 112 | 122 | 132 | 142 | 152 | 162 | 172 | |
00:55:10 | 91 | 91 | 101 | 111 | 121 | 131 | 141 | 151 | 161 | 171 | |
00:55:20 | 90 | 90 | 100 | 110 | 120 | 130 | 140 | 150 | 160 | 170 | |
00:55:30 | 89 | 89 | 99 | 109 | 119 | 129 | 139 | 149 | 159 | 169 | |
00:55:40 | 88 | 88 | 98 | 108 | 118 | 128 | 138 | 148 | 158 | 168 | |
00:55:50 | 87 | 87 | 97 | 107 | 117 | 127 | 137 | 147 | 157 | 167 | |
00:56:00 | 86 | 86 | 96 | 106 | 116 | 126 | 136 | 146 | 156 | 166 | |
00:56:10 | 85 | 85 | 95 | 105 | 115 | 125 | 135 | 145 | 155 | 165 | |
00:56:20 | 84 | 84 | 94 | 104 | 114 | 124 | 134 | 144 | 154 | 164 | |
00:56:30 | 83 | 83 | 93 | 103 | 113 | 123 | 133 | 143 | 153 | 163 | |
00:56:40 | 82 | 82 | 92 | 102 | 112 | 122 | 132 | 142 | 152 | 162 | |
00:56:50 | 81 | 81 | 91 | 101 | 111 | 121 | 131 | 141 | 151 | 161 | |
00:57:00 | 80 | 80 | 90 | 100 | 110 | 120 | 130 | 140 | 150 | 160 | |
00:57:10 | 79 | 79 | 89 | 99 | 109 | 119 | 129 | 139 | 149 | 159 | |
00:57:20 | 78 | 78 | 88 | 98 | 108 | 118 | 128 | 138 | 148 | 158 | |
00:57:30 | 77 | 77 | 87 | 97 | 107 | 117 | 127 | 137 | 147 | 157 | |
00:57:40 | 76 | 76 | 86 | 96 | 106 | 116 | 126 | 136 | 146 | 156 | |
00:57:50 | 75 | 75 | 85 | 95 | 105 | 115 | 125 | 135 | 145 | 155 | |
00:58:00 | 74 | 74 | 84 | 94 | 104 | 114 | 124 | 134 | 144 | 154 | |
00:58:10 | 73 | 73 | 83 | 93 | 103 | 113 | 123 | 133 | 143 | 153 | |
00:58:20 | 72 | 72 | 82 | 92 | 102 | 112 | 122 | 132 | 142 | 152 | |
00:58:30 | 71 | 71 | 81 | 91 | 101 | 111 | 121 | 131 | 141 | 151 | |
00:58:40 | 70 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140 | 150 | |
00:58:50 | 69 | 69 | 79 | 89 | 99 | 109 | 119 | 129 | 139 | 149 | |
00:59:00 | 68 | 68 | 78 | 88 | 98 | 108 | 118 | 128 | 138 | 148 | |
00:59:10 | 67 | 67 | 77 | 87 | 97 | 107 | 117 | 127 | 137 | 147 | |
00:59:20 | 66 | 66 | 76 | 86 | 96 | 106 | 116 | 126 | 136 | 146 | |
00:59:30 | 65 | 65 | 75 | 85 | 95 | 105 | 115 | 125 | 135 | 145 | |
00:59:40 | 64 | 64 | 74 | 84 | 94 | 104 | 114 | 124 | 134 | 144 | |
00:59:50 | 63 | 63 | 73 | 83 | 93 | 103 | 113 | 123 | 133 | 143 | |
01:00:00 | 62 | 62 | 72 | 82 | 92 | 102 | 112 | 122 | 132 | 142 | |
01:00:10 | 61 | 61 | 71 | 81 | 91 | 101 | 111 | 121 | 131 | 141 | |
01:00:20 | 60 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140 | |
01:00:30 | 59 | 59 | 69 | 79 | 89 | 99 | 109 | 119 | 129 | 139 | |
01:00:40 | 58 | 58 | 68 | 78 | 88 | 98 | 108 | 118 | 128 | 138 | |
01:00:50 | 57 | 57 | 67 | 77 | 87 | 97 | 107 | 117 | 127 | 137 | |
01:01:00 | 56 | 56 | 66 | 76 | 86 | 96 | 106 | 116 | 126 | 136 | |
01:01:10 | 55 | 55 | 65 | 75 | 85 | 95 | 105 | 115 | 125 | 135 | |
01:01:20 | 54 | 54 | 64 | 74 | 84 | 94 | 104 | 114 | 124 | 134 | |
01:01:30 | 53 | 53 | 63 | 73 | 83 | 93 | 103 | 113 | 123 | 133 | |
01:01:40 | 52 | 52 | 62 | 72 | 82 | 92 | 102 | 112 | 122 | 132 | |
01:01:50 | 51 | 51 | 61 | 71 | 81 | 91 | 101 | 111 | 121 | 131 | |
01:02:00 | 50 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | |
01:02:10 | 49 | 49 | 59 | 69 | 79 | 89 | 99 | 109 | 119 | 129 | |
01:02:20 | 48 | 48 | 58 | 68 | 78 | 88 | 98 | 108 | 118 | 128 | |
01:02:30 | 47 | 47 | 57 | 67 | 77 | 87 | 97 | 107 | 117 | 127 | |
01:02:40 | 46 | 46 | 56 | 66 | 76 | 86 | 96 | 106 | 116 | 126 | |
01:02:50 | 45 | 45 | 55 | 65 | 75 | 85 | 95 | 105 | 115 | 125 | |
01:03:00 | 44 | 44 | 54 | 64 | 74 | 84 | 94 | 104 | 114 | 124 | |
01:03:10 | 43 | 43 | 53 | 63 | 73 | 83 | 93 | 103 | 113 | 123 | |
01:03:20 | 42 | 42 | 52 | 62 | 72 | 82 | 92 | 102 | 112 | 122 | |
01:03:30 | 41 | 41 | 51 | 61 | 71 | 81 | 91 | 101 | 111 | 121 | |
01:03:40 | 40 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | |
01:03:50 | 39 | 39 | 49 | 59 | 69 | 79 | 89 | 99 | 109 | 119 | |
01:04:00 | 38 | 38 | 48 | 58 | 68 | 78 | 88 | 98 | 108 | 118 | |
06:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
on my TT sheet I have:
Name | Surname | Age Range (column K) | Time (Column N) | Point (Column O) | Should be | |
Alan | Smith | 50-54 | 0:35:43 | 248 | 247 | |
Bernie | Jones | 40-44 | 0:52:12 | 129 | 128 | |
Cathy | Fish | S | 0:28:59 | 249 | 248 | |
Dorothy | Day | 45-49 | 0:50:34 | 149 | 148 | |
Samatha | Fox | 40-44 | 0:35:45 | 228 | 227 | |
Donavan | August | S | 1:03:08 | 44 | 43 | |
Mike | Smith | 40-44 | 0:48:47 | 150 | 149 | |
Nevile | Gold | 40-44 | 0:48:48 | 150 | 149 |
for Points i have the following formula: =IFERROR(INDEX(('8km Points'!$C$4:$L$234),MATCH(N3,'8km Points'!$B$4:$B$234,1),MATCH(K3,'8km Points'!$C$3:$L$3,0)),0)
the results are giving me the points for the time over the 10sec and not under the 10sec so the times should be taken as
0:35:50 instead of 0:35:40
0:52:20 instead of 0:52:10
0:29:00 instead of 0:28:50
0:50:40 instead of 0:50:30
0:35:50 instead of 0:35:40
1:03:10 instead of 1:03:00
0:48:50 instead of 0:48:40
0:48:50 instead of 0:48:40
how do I correct my formula so that it gives me the correct points based on the time?