Data with values separated by dash, duplicate data and extract all values possible

Hello,

If anyone could offer help with the following it would a huge time-saver though I understand that it might be a difficult problem to solve.

I have a "Data" section which contains all the values to be processed - what I would like to do is the following:

extract all the first values, in a duplicated version of the original data
extract all the second values, in another duplicated version of the original
extract all the third values, in another duplicated version of the original
extract all the first and second values, in another duplicated version of the original

and so on, until all possible values are extracted.

A few other points: All values in the data section are separated by a dash. The data are always numeric.

In the attachment I am using formulas to achieve the results.

If anyone knows how the above can be achieved with vba it would be greatly appreciated.

Thank you

Hi

Here's some of it. You should be able to expand for any remaining combinations. If you have a variable number of items (3, or 6) etc, you may have to put in tests to see if they are going to be run.

Please Login or Register  to view this content.

rylo