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



"Mark" wrote in message
...
Hi,
I looking for best min_result in table below:

Name Data Distance
A 2.5 150
B 6.5 250
A 5.6 123
A 9.5 121
B 3.5 120
B 4.8 150
A 6.8 200

min_result = sum of three min (the least) data (column 2)
for Name in column 1.

Important remark!!!
Necessary condition: Distance (sum in column 3) of those
three data must be 500.
Min_result can be higher result if nacessary condition
can't be perform.
Is there any way to resolve my problem?
Any help will be appreciate.
Regards
Mark