palaeontology
Active Member
- Joined
- May 12, 2017
- Messages
- 444
- Office Version
- 2016
- Platform
- Windows
I have a list in the range ... CM37:CW37
I have a value in ... BY37
I'd like to find the first number in the list range that is larger than the value in BY37.
eg: List Range in CM37:CW37 ....
<tbody>
</tbody>
Value in BY37 ...
247.9
so the first value in the list range that is larger than 247.9 is the value 249
I've tried a few combinations of match etc, but each falls short of what i need.
Any ideas ?
Kind regards,
Chris
<tbody>
</tbody>
I have a value in ... BY37
I'd like to find the first number in the list range that is larger than the value in BY37.
eg: List Range in CM37:CW37 ....
199.0 | 209 | 219 | 229 | 239 | 249 | 259 | 269 | 279 | 289 | 299 |
<tbody>
</tbody>
Value in BY37 ...
247.9
so the first value in the list range that is larger than 247.9 is the value 249
I've tried a few combinations of match etc, but each falls short of what i need.
Any ideas ?
Kind regards,
Chris
<tbody>
</tbody>