Hi All – I have the below ranges in different cells in Excel:

4-24, 25-72, 73-96, 96+

What I need to write a formula for, is to show in another column when searching all the above, which one is the smallest range.

Hope that makes sense.

Thanks

​Hi All – I have the below ranges in different cells in Excel: 4-24, 25-72, 73-96, 96+ What I need to write a formula for, is to show in another column when searching all the above, which one is the smallest range. Hope that makes sense. Thanks  Read More

​