|
Re: Culling consecutive numbers into ranges
Thank you for the quick response.
I tried both the vb script and the formula option.
The vb script gave me a runtime 6: overflow error.
I'm not sure, but it could be because my data set is in the thousands. Although I tried it with a subset of about 20 numbers and had the same failure.
I then tried the formula version and I'm not sure exactly what it did (or was supposed to do) It seemed to fill column B with numbers, but they were not they were not really ranges. I'm not sure how to explain it. Perhaps you could explain what the output should look like.
Thank you very much for your help. I really appreciate it.
|