Condense continuous sequences.

[Common Wealth]

Hello,

The attached sample workbook is probably the clearest description of this. With the "Input" tab being my current data, and the "output" tab being my desired display.

I am looking for a macro that will condense a sequence of continuous numbers in one column, into two columns showing only the first and last integer of the original sequence, such that when column "F" contains numbers "1,2,3,....9" A macro can be run so that columnF will display "1" and columnG will display "9" summarizing the entire sequence.

It does not have to display perfectly, if extra columns are left over that is no problem. I used highlighting in the workbook for readability but these would not normally be present.

Thanks very much for any help that can be provided!



-Becky

[mehmetcik]

Hi

This file meets your requirements.

Enjoy.

[watersev]

hi Common Wealth, option, press Run button or run code "test"