Hi,

I have list of Col. A

60,916
89,343
87,313
60,916
89,343
56,855
71,068
89,343
89,343
89,343
89,343
89,343
89,343
89,343
74,452
74,452
89,343
85,282
85,282
89,343
61,592
58,659
14,665
52,794
89,343
52,794
89,343
89,343
89,343
52,794
89,343
85,282
89,343
52,794
89,343
52,794
89,343
89,343
64,525
64,525
64,525
64,525
64,525
64,525
61,592
55,726
61,592
61,592
58,659
64,525
64,525
64,525
64,525
64,525
64,525
64,525
55,726
64,525
64,525
64,525
64,525
58,659
74,452
64,525
64,525
64,525
64,525
64,525
64,525
64,525
61,592
74,452
71,068
64,525
64,525
64,525
58,659
61,592
61,592
68,496
46,928
61,592
64,525
64,525
64,525
38,128
32,263
64,525
32,263
64,525
32,263
64,525
71,024
69,629
71,024
68,092
71,024

and Col. B

74,452
74,452
4,36,873
4,70,310
3,80,383
1,45,520
4,66,340
3,10,893
74,452
5,10,334
5,07,401
4,95,669
1,48,904
4,48,742
11,53,339
4,38,593
1,34,916
4,46,715

I need formule to find best / accurate sum of combinations (values) in Col. A to each value in Col. B.

Kindly help me in this.

Regards,
Sree