I am wanting to retrieve ranges of the sequential numbers in a list of numbers. For example..
1
2
3
4
5
6 "1-6"
8
9
10 "8-10"
14
15
16 "14-16"
What is the best way to do this? Anyone have a quick solution?
I am wanting to retrieve ranges of the sequential numbers in a list of numbers. For example..
1
2
3
4
5
6 "1-6"
8
9
10 "8-10"
14
15
16 "14-16"
What is the best way to do this? Anyone have a quick solution?
You could loop through the series using vba?
Please see attached macro based solution I have done for you.
Please Login or Register to view this content.
Regards
MrExcelPro
That works well, but it will up the message box with more left. Is there a way to put that information into the spread sheet?
I'm not sure I know what you mean. Do you want to insert the missing numbers or do you want to record the list of ranges, this method indentifies the ranges as you asked?
Or maybe just a helper column
With your numbers in Column A, begining A2
Helper Column (This can be hidden)
In B2
In C2Please Login or Register to view this content.
Drag/Fill both DownPlease Login or Register to view this content.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Just the record of the sequential ranges.
Marcol! That works If there is a macro that would be good too. Thanks for the help guys.
Try this UDF as a posible alternative solution
Please Login or Register to view this content.
Enter in Excel like so
syntax
ListSequences(the first cell in your sequence,the absolute row for the first cell)
e.g.
Drag/Fill DownPlease Login or Register to view this content.
Hope this helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks