Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
Sorting triplets... | Excel Worksheet Functions | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Pairs, Triplets, Quads... | Excel Programming |