Could some one please help me with a formula that can give the smallest value within a defined range.
So let's say in column 1 there are vales and in column 3 I have manually copied the smallest values between 1-1.9999, 2-2.9999 and 3-3.9999. Is there a formula I could write in column 3 cells that would allow me to do this?
<tbody>
</tbody>
Any help will be appreciated. Cheers
So let's say in column 1 there are vales and in column 3 I have manually copied the smallest values between 1-1.9999, 2-2.9999 and 3-3.9999. Is there a formula I could write in column 3 cells that would allow me to do this?
1.456 | 1.456 | |
1.896 | 2.215 | |
1.985 | 3.333 | |
2.215 | ||
2.665 | ||
2.899 | ||
3.333 | ||
3.885 | ||
3.985 | ||
<tbody>
</tbody>
Any help will be appreciated. Cheers