Sorry, not sure how to title this problem. I want to test range values. For example, in cell A1, I have a value: 100-500; A2, 501-1000; A3, 1001-1500, and so forth. I want to test each cell (A1 thru Ax...), whether my input value (for example) is within the range. For example, if my input value is 200, then A1 is true and I would do something. What is the best way of accomplishing this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Compare range values
- Thread starter dave8
- Start date
-
- Tags
- compare range values
