On Mon, 11 Jul 2005 13:38:20 -0400, Bruce Bowler put fingers to keyboard
and said:

On Mon, 11 Jul 2005 18:24:18 +0100, Nigel put fingers to keyboard and
said:

One qualifier to help with the logic, when you say closest do you mean less
than or more than?

eg
ALL has 11.50 and 12.10
SOME value = 12.00
which in ALL is closest?

Minimize the absolute value of the difference (so in your example, 12.1
is closest). In the event that ALL has 11.9 and 12.1 and some is 12.0,
either one is acceptable

a couple of other tidbits that might simplify things...

the first ALL will ALWAYS be less than the first SOME
the last ALL will ALWAYS be greater than the last SOME

there will NEVER be adjacent SOMEs in the ALL

--
+-------------------+---------------------------------------------------+
Bruce Bowler | In theory, there is no difference between theory
1.207.633.9600 | and practice. In practice, there is. - Anon
|
+-------------------+---------------------------------------------------+