On Mon, 15 Nov 2004 07:12:46 -0500, "Tom Ogilvy" wrote:

Can you sort your data on the "Data" column ascending? Then you take the
first 3 sequential cells that sum to greater than 500.

--
Regards,
Tom Ogilvy

Tom,

Apparently the result may not be from sequential entries. The OP gives an
example:

======================
Name Data Distance
A 1.1 11
A 2.3 20
A 3.5 12
A 5.9 470

Proper effect:
min_result = 1.1 + 2.3 + 5.9 = 9.3 (distance 501)
======================

Any thoughts? (Other than generating all possible three row entries for each
name)






--ron