simplification problem (only for expert!)
Hi TOM!!!
Data can't be sort..there are thousands.
I'd like resolve in VBA (by recurrence).
Best regards
mark
-----Original Message-----
Can the data be sorted?
--
Regards,
Tom Ogilvy
"Mark" wrote in message
...
Hi,
I struggling with the following problem.
I have in two column data:
column1 column2
200 10
30 50
50 40
10 20
...etc. thousand records
I'd like find max sum (two elements) of column1.
Nacessary condition: sum of these two element in column2
70.
E.G. satisfy condition is:
sum of column1: 30+50 = 80
becouse condition is fulfil, sum of column2: 50+40 70
How resolve this task in VBA by selection and
iteration??
Many thanks in anticipation.
Regards
Mark
.
|