find result - only for expert
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
|