Numeric intervals

Hi I have a big group of numeric values and I would like to automatically group them in regular intervals

Example: I have 1,2,3,4,7,8,9,11,12,13,14 I would like to automatically define ranges like: 1-4, 7-9, 11-14

Any ideas? is it possilbe to do this in Excel? R?

Many thanks!

Originally Posted by HaHoBe

Hi, staedtler,

maybe like

Please Login or Register  to view this content.

Ciao,
Holger

Thanks mate for the replay , but the case is that I have used that array only as an example.
I have actually prety big gorup of numeric values from different datasets, therefore I would need a generic formula (or code) doing that.
Cheers
M

or maybe like

Please Login or Register  to view this content.

Originally Posted by nilem

or maybe like

Please Login or Register  to view this content.

Thanks nilem!!!
this works like a charm! great help, thank you!

The only thing to improve is when you have only one number in a range, the VB code repeat that number:
for example, we have 1,2,3,4,7,9,10,11
the VB code returns:1-4,7-7,9-11,

and there is a comma (,) at the end of the range....

Many thanks mate for a great help!!!
Cheers
M

as an option

Please Login or Register  to view this content.