Situation: chemical reactants are measured; samples are mixed, each sample is
measured in two different enviroments, samples are measured in triplets, the
result should be an ideal path of the reactant through the changes of the
environment.
Algorithm: triplets of values - the amount of triplets is given, the range
of values is given (confined) - I need to sort (extract from) these triplets
in a way that - all values from the given range are covered by the selected
triplets (which will cover the whole path of the reactant through the changes
of the environment) and each value repeats between two triplets (this covers
the measured differences). an example might look like:

From these:

{3,223;3,223;3,224}
{0,121;0,122;6,782}
{6,782;0,122;0,122}

I need to get these:

{3,223;0,122;6,782},{3,223;8,456;12,354},{33,012;8 ,456;6,782},{33,012;12,354;0,122}

This wouldn't be a problem if I had the time to code a simple C app...but -
how do I do this in Excel? Thank you for any ideas!

What algorithm is used to derive the second set of numbers from the first?

"Mac" wrote:

Situation: chemical reactants are measured; samples are mixed, each sample is
measured in two different enviroments, samples are measured in triplets, the
result should be an ideal path of the reactant through the changes of the
environment.
Algorithm: triplets of values - the amount of triplets is given, the range
of values is given (confined) - I need to sort (extract from) these triplets
in a way that - all values from the given range are covered by the selected
triplets (which will cover the whole path of the reactant through the changes
of the environment) and each value repeats between two triplets (this covers
the measured differences). an example might look like:

From these:

{3,223;3,223;3,224}
{0,121;0,122;6,782}
{6,782;0,122;0,122}

I need to get these:

{3,223;0,122;6,782},{3,223;8,456;12,354},{33,012;8 ,456;6,782},{33,012;12,354;0,122}

This wouldn't be a problem if I had the time to code a simple C app...but -
how do I do this in Excel? Thank you for any ideas!

That's the one I describe above: all (or as much as possible) values are
covered and each is repeated throughout two triplets.

"Mike H" wrote:

What algorithm is used to derive the second set of numbers from the first?

"Mac" wrote:

Situation: chemical reactants are measured; samples are mixed, each sample is
measured in two different enviroments, samples are measured in triplets, the
result should be an ideal path of the reactant through the changes of the
environment.
Algorithm: triplets of values - the amount of triplets is given, the range
of values is given (confined) - I need to sort (extract from) these triplets
in a way that - all values from the given range are covered by the selected
triplets (which will cover the whole path of the reactant through the changes
of the environment) and each value repeats between two triplets (this covers
the measured differences). an example might look like:

From these:

{3,223;3,223;3,224}
{0,121;0,122;6,782}
{6,782;0,122;0,122}

I need to get these:

{3,223;0,122;6,782},{3,223;8,456;12,354},{33,012;8 ,456;6,782},{33,012;12,354;0,122}

This wouldn't be a problem if I had the time to code a simple C app...but -
how do I do this in Excel? Thank you for any ideas!