LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mac Mac is offline
external usenet poster
 
Posts: 213
Default Sorting triplets...

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Values Without Sorting Formulas SBX Excel Discussion (Misc queries) 2 April 12th 09 11:17 PM
Automatic sorting (giving max and min) based on custom sorting lis Joe Lewis[_2_] Excel Worksheet Functions 4 November 23rd 08 05:12 AM
Sorting triplets... Mac Excel Worksheet Functions 2 November 14th 07 10:35 AM
Sorting VLookup vs Sorting SumProduct Lauren Excel Discussion (Misc queries) 1 August 21st 07 12:19 AM
Pairs, Triplets, Quads... Mike NG Excel Programming 10 June 5th 05 06:48 PM


All times are GMT +1. The time now is 06:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"