http://m.kin.naver.com/mobile/qna/detail.nhn?d1id=1&dirId=102020101&docId=270655368 아내가 합산된 개요의 구체적인 값을 알아내야 하는데 합산된 엑셀 데이터와 171개의 각각 데이터가 있습니다.
합산된 값이 무슨 데이터를 더해서 얻어진 건지 알아내고 싶습니다. 어떤 방법이 가장 쉬울까요?
일단 for 문을 9개 중첩해서 합이 같은 경우 나타나게 하는데.......... 너무 너무 오래 걸립니다. 일단 컴터는 켜 놓고 잠들여고 합니다. 도와주세요.
----
데이터는 아래와 같습니다.
1,257,605,320
395,900,000
339,980,000
100,700
74,611,800
58,850,000
58,447,840
49,972,450
33,812,320
33,160,800
32,450,000
15,537,200
30,800,000
29,403,000
28,976,730
13,750,000
27,500,000
13,717,000
26,180,000
25,135,820
25,085,080
25,000,000
2,013,000
23,199,000
24,144,000
360,000
22,593,310
22,593,310
20,102,800
20,000,000
32,560,000
7,598,800
17,186,400
7,348,000
16,311,450
774,000
15,855,300
15,400,000
15,254,800
2,271,540
14,584,240
14,500,000
14,500,000
14,179,000
6,209,280
7,260,000
13,287,000
13,000,000
12,977,390
5,655,100
12,530,000
10,200,960
4,840,000
9,800,000
9,783,400
9,757,000
9,735,000
433,660
9,600,000
154,000
9,333,280
176,000
220,000
225,000
8,119,070
8,000,000
242,000
360,000
380,000
385,000
7,131,150
440,000
440,000
880,000
6,864,000
1,216,000
1,220,000
6,470,000
1,588,000
1,654,400
1,760,000
5,602,300
5,412,000
1,781,000
4,991,800
1,815,000
2,453,000
2,508,000
4,680,000
2,805,000
3,365,000
4,400,000
3,557,000
4,345,000
4,202,000
3,780,000
4,079,760
3,960,000
3,952,000
3,830,000
4,131,600
2,130,000
4,389,000
3,520,000
3,480,000
4,505,000
3,300,000
3,300,000
3,000,000
2,871,000
2,871,000
2,856,660
4,620,000
2,690,210
2,640,000
4,700,000
4,966,500
5,310,000
2,226,400
6,248,000
2,050,400
2,030,900
6,600,000
1,921,700
1,819,540
27,314,980
1,811,950
6,647,300
7,670,300
1,709,760
1,700,000
6,930,000
3,937,500
1,320,000
1,301,360
1,300,000
1,297,000
1,265,000
6,982,500
6,997,100
1,210,000
1,091,550
1,073,600
990,000
905,000
8,600,000
880,000
8,690,000
720,000
706,200
600,000
9,176,200
9,570,000
9,676,700
390,720
389,400
9,939,600
12,540,000
14,652,000
16,997,600
249,560
246,800
243,000
17,864,000
19,033,300
24,400,000
24,950,000
27,996,100
150,480
104,280
82,500,000
---
위의 데이터를 조합해 찾아야 할 합산자산금액은 아래와 같습니다.
2,030,000
56,747,260
16,236,000
9,600,000
24,790,150
84,869,960
1,265,000
1,257,605,320
64,246,840
17,141,080
39,668,980
13,000,000
176,539,000
49,079,530
37,095,280
363,897,520
33,748,000
37,047,600
149,425,100
34,729,300
19,540,400
16,410,900
85,839,500
56,020,000
19,120,000
10,210,000
28,844,260
25,135,820
56,980,000
17,318,900
41,052,780
36,460,800
24,532,500
52,103,820
2,871,000
880,000
395,900,000
95,102,300
63,230,000