I have several sheets wherein I need to ensure and validate that all the 'numbers' (values) within predetermined ranges are actually numbers. We can assume that all numeric values are valid. The ranges however are not exactly predetermined, since the are re-populated daily with new data imports so that will mean more rows - however the starting cell reference, O3 is expected to always be the same.
Currently I am using COUNT(O3:BB1740)
and COUNTA(O3:BB1740)
and then finding the difference between the two values (if the difference is not zero it indicates that there is data within the range that is not numeric).
This method seems hackish to me so I am looking for a reasonable alternative.
- If possible, how would I isolate and identify the invalid value (I know I can loop though each cell but I am looking for a non-macro approach if possible)
(It would be awesome if there was a IsNumber
function for ranges)