culling consecutive numbers from an array

[qalfesq]

Hi everyone

I'm new to this forum, and I'm working in a project with vba and I having a problem Culling consecutive numbers from an array as depicted below:

there are 4 ranges of numbers

range A- 1 to 24
range B- 33 to 56
range C- 287 to 310
range D- 330 to 353

the array giving can contain any combination of numbers between the 4 ranges above, example as below:

1
2
3
4
5
8
22
23
24
33
34
35
40
287
288
290

the result would be something like :

RangeA: 1-5,8,22-24
RangeB: 33-35,40
RangeC: 287-288,290
RangeD: Nothing

I'll really appreciate for any help!

[rylo]

Hi

See how this goes

Please Login or Register  to view this content.

This will put the output into column B.


rylo