Return the combination of numbers that sum or match a target value

rye_sniper

New Member
Joined
Apr 10, 2014
Messages
7
I badly need help! I have a long list of amount of bank transactions. I need to find 44,522.6 in that long list (found below)

4,950.00
26,400.00
15,500.00
1,889.56
4,380.75
6,603.75
32,114.34
3,000.00
5,000.00
50,000.00
30,100.00
62,317.00
6,627.80
2,580.00
3,230.00
4,229.54
89,084.00
31,000.00
7,088.55
19,107.14
1,247.20
1,936.00
1,000,000.00
6,500.00
21,405.00
9,450.00
19,500.00
98,478.27
51,927.47
3,250.00
4,910.00
8,200.00
19,985.00
592,800.00
161,440.00
95,375.00
7,925.00
50,000.00
821,258.38
132,631.57
3,300.00
2,439.00
17,600.00
3,650.00
14,000.00
3,850.00
31,371.74
70,360.00
47,654.40
10,000.00
15,506.40
26,556.55
2,172.80
100,000.00
40,100.00
629.96
7,330.92
1,445,850.00
4,000.00
4,372.25
5,561.25
12,920.58
6,500.00
10,302.60
50,920.00
1,000.00
60,418.35
8,325.00
3,965.00
2,700.00
1,870.00
42,815.00
17,000.00
8,000.00
1,851.00
1,469.00
44,492.84
6,450.50
98,478.27
7,366.03
63,222.50
31,611.25
41,197.87
11,040.00
13,000.00
4,123.25
38,506.80
54,800.00
31,000.00
3,250.00
3,600.00
2,500.00
2,500.00
8,750.00
5,150.00
19,460.00
6,072.50
1,630.00
6,265.80
2,436.00
12,225.00
70,915.20
4,500.00
2,500.00
20,245.00
1,882.00
9,715.27
39,522.47
2,400.00
38,478.00
29,280.00
27,096.00
3,231.00
3,294.00
1,424.00
34,000.00
10,670.00
5,000.00
2,312.50
26,400.00
16,740.00
6,320.00
37,036.80
8,441.00
9,858.50
1,280.00
5,794.49
31,235.10
163,014.33
84,801.91
638.97
65,033.91
3,463.00
59,500.00
1,500.00
6,300.00
37,790.00
3,150.00
2,050.00
12,705.00
8,400.00
254,972.64
7,188.00
4,968.15
1,085.00
2,650.00
60,000.00
25,000.00
4,406.50
13,125.00
3,031.00
6,918.75
40,000.00
41,309.83
13,200.00
5,710.00
5,200.00
481.64
5,390.00
4,655.00
4,410.00
7,986.50
38,936.80
1,000,000.00
611.00
1,900.00
132,000.00
38,000.00
6,955.00
7,350.00
40,937.50
28,000.00
64,520.00
38,898.80
555.00
15,979.00
5,355.16
5,353.23
5,882.11
3,348.89
3,874.83
11,130.48
40,750.00
4,229.54
2,076.52
134,345.00
2,500.00
97,069.00
200.00
506,304.81
218,484.07
34,147.02
2,388.00
1,500.00
108,034.08
5,655.00
12,600.00
7,323.00
16,729.15
16,640.00
2,000.00
7,913.50
4,450.00
12,540.00
3,240.00
36,546.00
3,000.00
1,445,850.00
19,107.14
5,500.00
42,536.80
5,000.00
135,366.06
82,562.00
18,726.75
22,300.00
625.00
4,400.00
951.00
3,720.00
1,000.00
3,125.00
18,437.50
23,653.39
7,948.50
35,100.00
5,100.00
5,670.00
1,987.00
40,630.31
46,246.80
4,575.75
3,527.00
54,600.00
74,869.91
100,000.00
433,855.06
5,795.00
20,315.00
1,950.00
166,589.76
5,000.00
4,000.00
2,500.00
2,006.56
14,060.00
2,000.00
24,435.00
18,210.00
22,142.00
4,344.00
22,800.00
957.09
5,000.00
1,470.00
10,000.00
130,300.00
2,800.00
52,546.80
3,060.00
20,156.25
7,187.50
8,750.00
12,190.00
6,615.65
12,935.90
1,000,000.00
331,226.59
9,900.00
1,500.00
5,600.00
7,405.09
168,750.00
26,347.00
1,015.60
129,039.00
42,505.01
2,140.00
840.00
7,000.00
6,500.00
20,000.00
4,676.50
3,320.00
3,430.00
3,900.00
54,960.00
7,600.00
4,540.00
1,225.00
77,193.98
5,366.00
37,350.00
907,997.50
20,000.00
9,565.00
30,156.25
3,593.75
18,906.25
10,000.00
432,900.00
2,497.00
177.49
199,160.00
19,780.00
2,290.00
25,000.00
54,560.00
52,272.00
11,845.25
9,374.66
2,086.00
10,000.00
267,857.15
4,000.00
1,650.00
23,961.00
29,900.00
142,065.00
1,408.05
12,222.00
221,429.87
2,300.00
14,782.00
21,826.00
29,692.50
80.00
126,550.00
60.00
9,680.00
975.00
42,548.10
4,655.00
2,558.00
17,600.00
37,096.00
274.50
200.00
15,000.00
1,753.55
22,190.00
1,211.00
984.00
1,530.00
390.00
7,000.00
134,200.00
187,247.94
78,620.02
10,084.01
129,038.99
59,827.44
3,439.00
24,830.00
16,730.19
24,116.02
6,691.00
4,000.00
5,000.00
5,000.00
5,094.00
10,196.55
54,560.00
296,600.00
4,200.00
25,173.50
950.00
8,750.00
6,875.00
28,125.00
6,000.00
20,687.98
15,974.32
77,670.89
64,656.08
5,500.25
35,500.00
356,139.70
1,530,757.47
4,100.00
3,100.00
1,225.00
1,800.00
22,295.00
20,641.27
150,181.96
36,483.68
44,875.00
1,500.00
40,000.00
7,178.00
15,215.00
1,512.00
66,900.00
40,000.00
2,834.00
2,295.00
6,691.21
3,000.00
1,050.00
2,160.00
7,549.10
3,762.00
42,815.00
20,971.39
153,550.00
5,279.54
2,076.52
7,000.00
1,500.00
20,000.00
2,667.65
5,375.00
56,330.00
20,798.49
43,750.00
2,500.00
137,012.50
7,600.00
5,000.00
2,400.00
450.00
2,500.00
25,173.50
2,900.00
1,181.25
8,432.56
1,000.00
3,400.00
3,790.00
100,000.00
8,147.50
2,495.29
41,381.56
1,385.00
10,175.00
9,630.25
3,557.60
43,902.54
15,956.00
6,500.00
5,880.00
15,000.00
1,300.00
5,590.00
1,463.50
5,673.00
6,106.00
1,860.00
7,720.00
155,336.00
171,480.00
213.00
6,074.00
150.00
3,600.00
200.00
68,080.00
15,000.00
2,547.00
1,417.10
25,800.00
1,519.50
129,944.52
912.00
5,733.80
10,182.72
1,000,000.00
1,735.00
144,000.00
1,108.00
4,200.00
2,579.62
160,000.00
56,330.00
14,700.00
800.00
8,125.00
8,750.00
30,625.00
6,294.00
45,399.41
500.00
60,000.00
140,750.00
3,040.00
7,000.00
9,779.00
40,000.00
2,000.00
4,995.00
27,000.00
116,550.00
72,093.00
200.00
1,445,850.00
4,791.00
2,230.00
52,740.00
10,755.48
590.00
34,740.00
7,425.00
13,300.00
31,611.25
63,222.50
8,550.00
18,050.00
4,574.98
4,000.00
3,000.00
5,910.00
2,648.65
33,720.00
101,918.84
20,892.87
1,740.00
17,662.67
3,052.60
3,270.00
9,705.15
10,000.00
40,000.00
1,948.00
1,216.00
50,000.00
17,400.00
33,600.00
7,698.00
146,400.00
3,690.00
3,980.00
1,200.00
5,400.00
54,930.00
94,062.50
55,625.00
1,400.00
2,250.00
1,000.00
200.00
4,011.50
9,555.00
4,120.00
63,800.00
68,950.00
2,700.00
11,290.06
3,380.00
8,666.62
11,970.00
12,287,476.80
43,353.40
16,250.00
6,500.00
6,935.00
3,900.00
1,900.00
27,450.00
1,069.00
2,100.00
9,500.00
3,152.00
16,500.00
3,300.00
7,288.00
8,000.00
5,975.50
48,480.00
4,130.00
2,345.00
1,200.00
5,627.50
6,000.00
10,000.00
3,000.00
3,000.00
3,750.00
11,000.00
198.25
11,000.00
3,750.00
10,560.00
52,580.00
31,400.00
300.00
2,400.00
23,250.00
225.00
3,375.00
9,908.00
60,000.00
200.00
10,795.00
42,417.57
8,125.00
4,023.50
2,609.50
24,100.00
1,097.20
129,038.99
10,420.95
287,850.00
22,187.50
20,000.00
880.00
1,000.00
5,266.00
10,000.00
980.00
13,051.00
6,260.43
42,151.64
1,740.00
725.00
1,600.00
199,160.00
3,850.00
50,000.00
600.00
800.00
600.00
1,197.00
8,960.00
10,434.05
5,100.00
5,000.00
7,873.12
4,000.00
97,950.00
47,850.00
3,900.00
74,000.00
200.00
200.00
200.00
20,007.75
64,000.00
5,220,000.00
210,000.00
1,500.00
7,286.00
1,960.00
10,000.00
1,482.00
47,375.00
790.00
26,033.15
2,805.00
19,107.14
926.00
44,492.84
23,809.25
42,600.60
3,066.40
5,600.00
1,500.00
11,120.00
1,370.00
4,995.00
4,390.00
11,600.00
1,210.00
4,740.00
1,200.00
2,500.00
49,080.00
50,000.00
3,450.00
44,703.42
1,017,928.80
493,375.83
1,417.00
27,600.00
5,560.00
2,076.52
39,218.75
8,750.00
13,281.25
6,250.00
3,395.70
3,773.00
14,879.20
270.00
1,050.00
1,785.00
166,715.00
8,867.31
35,000.00
2,500.00
3,285.70
1,500.00
4,870.00
2,500.00
3,500.00
9,900.00
4,000.00
7,800.00
2,500.00
1,445,850.00
1,573.75
3,000.00
115,797.99
5,000.00
247,225.00
3,225.00
63,985.45
100,000.00
4,889.25
56,170.29
16,714.31
3,677.82
80,000.00
156,750.00
1,152.00
2,355.00
31,700.00
2,000.00
450.00
48,480.00
865,000.00
41,621.86
4,284.00
2,156.00
7,000.00
6,460.20
3,880.00
200.00
50,000.00
5,539.40
19,969.52
3,120.00
700.00
3,354.00
1,000.00
13,000.00
2,480.00
7,550.00
250.00
3,170.00
884.80
33,000.00
1,460.00
23,940.00
140,750.00
17,400.00
2,500.00
7,500.00
200.00
13,500.00
1,900.00
4,227.50
5,250.00
49,080.00
133,524.23
10,004.00
1,074.00
17,699.62
85,902.03
3,000.00
210.00
400.00
1,200.00
19,483.00
4,600.00
5,530.00
531.00
2,000.00
5,825.00
3,949.50
125.00
27,656.25
10,335.53
9,922.46
104,424.49
9,375.00
115,781.25
12,500.00
10,000.00
40,266.83
6,500.00
2,947.00
4,851.00
50,000.00
570,000.00
10,235.31
8,167.54
60,000.00
200.00
750,000.00
500.00
285,000.00
5,752.70
554.00
4,000.00
2,600.00
85,830.54
19,107.14
19,547.56
9,576.66
6,195.50
135,100.00
3,300.00
1,055.00
37,802.00
1,800.00
25,315.00
5,766.08
3,900.00
205,800.00
5,210.00
11,890.00
3,315.98
3,950.00
1,500.00
2,112.00
3,482.08
12,500.00
11,240.60
49,080.00
48,664.00
1,215.00
2,200.20
1,230.00
13,900.00
90,000.00
22,000.00
1,007.80
229.40
3,125.00
143,301.20
44,769.42
42,968.75
11,718.75
51,875.00
21,250.00
70,000.00
6,250.00
3,125.00
23,125.00
13,125.00
126.23
1,662.00
44,492.84
18,050.00
8,550.00
106,292.93
6,815.00
120,008.75
56,424.88
5,418.00
3,850.00
3,403.50
20,000.00
18,700.00
9,000.00
3,854.65
4,717.15
2,320.00
8,496.68
34,130.00
99,444.25
7,083.10
2,000.00
100,342.00
135,930.00
10,000.00
10,800.00
49,080.00
60,000.00
30,000.00
22,500.00
3,270.00
26,280.00
4,380.00
5,049.25
95,726.82
2,115.00
9,485.00
56,575.00
618,000.00
605,640.00
20,834.44
5,031.03
4,780.00
767.20
659.44
6,990.00
1,100.00
2,400.00
1,939.00
350.00
3,505.80
673.75
8,125.00
5,625.00
24,531.25
11,875.00
3,125.00
3,000.00
230,664.00
10,500.00
44,468.84
3,500.00
98,657.00
12,732.30
113,275.00
122,815.00
6,140.00
1,150.00
2,800.00
5,277.25
9,645.80
814,653.45
587,165.32
200.00
2,205.00
2,400.00
2,250.00
200.00
200.00
200.00
750,000.00
500.00
1,430.88
9,713.75
13,760.00
1,140.00
15,200.00
215.00
1,170.00
70,516.74
940.00
720.00
1,682.00
15,500.00
1,417.10
2,076.52
6,159.88
5,009.00
3,531.75
2,500.00
7,226.00
7,779.04
1,445,850.00
50,000.00
37,350.00
40,850.00
23,030.00
99,914.58
32,200.00
200,595.00
4,000.00
260,417.36
419,145.81
2,545,015.00
185,000.00
10,000.00
50,587.72
25,625.00
1,195,016.62
3,750.00
9,375.00
5,625.00
6,406.25
69,375.00
8,750.00
7,187.50
12,300.00
4,279.00
50,000.00
3,773.00
200.00
1,385.00
1,500.00
3,864.05
10,000.00
200.00
4,600.75
74,920.00
3,234.50
13,469.00
14,250.00
500.00
90,172.00
16,850.00
10,687.50
650.00
1,350.00
6,000.00
10,000.00
1,500.00
2,250.00
13,600.00
19,167.00
40,000.00
18,476.01
4,495.00
2,900.00
6,960.00
63,400.00
10,138.43
6,235.75
3,058.86
9,900.00
1,738.50
3,600.00
5,000.00
10,040.00
349.63
2,060.00
35,000.00
229,926.00
1,682.00
4,300.00
50,000.00
6,680.00
2,874.00
7,590.00
4,692.25
4,182.50
23,475.56
7,489.76
50,781.25
15,000.00
16,093.75
17,500.00
9,687.50
15,625.00
47,542.77
42,827.00
219,232.03
750,000.00
677.36
149,413.58
5,630.00
200.00
30,000.00
19,404.00
41,619.00
58,965.77
5,151.00
6,500.00
24,500.00
4,800.00
10,434.05
181,190.00
83,945.60
14,100.00
33,582.50
3,165.96
12,300.00
158,575.37
7,240.70
15,921.26
14,595.18
35,100.00
4,560.75
80,106.60
1,300.00
5,750.00
3,115.50
4,318.56
5,909.60
2,000.00
13,742.00
50,000.00
3,379.00
80,579.91
12,500.00
6,875.00
64,375.00
38,525.60
6,800.00
1,970.00
27,645.00
106,312.50
9,390.92
1,524.00
43,113.55
12,250.00
110,634.92
67,500.00
2,250.00
1,500.00
10,621.63
246.00
5,400.00
110,525.00
20,000.00
20,000.00
1,190.00
6,093.75
64,843.75
12,500.00
4,892.25
2,200.00
2,382.50
598.99
8,550.00
18,050.00
63,222.50
13,300.00
6,327.24
16,225.47
44,492.84
31,611.25
10,094.00
1,449.75
750.00
680.00
4,300.00
201.02
6,001.00
6,000.00
300.00
420.00
17,995.00
3,585.75
6,000.00
2,300.00
133,680.00
1,280.00
1,662.75
352,812.77
135,330.00
225.00
1,400.00
900.00
4,300.00
8,859.32
4,073.00
4,475.72
4,845.00
19,954.72
129,038.99
10,000.00
2,515.00
84,920.00
58,000.00
2,550.00
9,081.34
2,277.00
3,700.00
305,000.00
8,107.00
5,000.00
2,932.65
11,875.00
38,593.75
182,939.64
57,675.00
33,294.39
7,983.35
6,006.40
200,000.00
6,712.80
17,645.77
29,366.34
2,120.00
100,188.00
3,800.00
8,150.00
1,000.00
10,000.00
111,025.00
1,200.00
2,777.88
6,000.00
4,500.00
200.00
2,420.50
1,500.00
2,500.00
5,795.00
80,000.00
2,400,000.00
500.00
865.00
48,437.50
178,688.73
3,000.00
7,390.00
1,662.00
210,180.00
8,190.26
3,203.05
5,591.50
7,423.10
1,650.00
58,000.00
2,530.00
32,584.96
200.00
15,594.28
8,279.88
1,135.70
5,777.00
3,437.50
86,755.16
1,061,650.00
57,500.00
14,843.75
11,875.00
2,270.00
5,220,000.00
3,654.70
495.00
14,335.67
8,661.08
13,597.95
13,150.00
11,676.75
36,653.28
32,405.31
12,000.00
53,000.00
6,500.00
32,600.00
5,248.00
138,854.06
32,000.00
2,971.00
129,038.99
53,568.88
9,798.89
3,564.14
1,500.00
5,120.96
4,191.31
4,742.94
37,101.07
8,906.25
81,562.50
4,375.00
49,062.50
25,937.50
84,103.44
3,300.00
6,968.25
864.40
3,430.00
200.00
10,000.00
3,000.00
1,800.00
7,578.25
6,090.00
4,053.00
21,600.00
45,000.00
2,149.59
16,562.50
1,875.00
18,750.00
2,659.75
834.00
2,216.00
825.00
180,000.00
755.70
32,031.37
4,937.00
2,480.00
14,375.00
4,062.50
3,000.00
3,390.84
131.00
3,999.12
3,232.50
8,025.00
5,051.00
7,154.40
3,800.00
269,529.40
153,412.00
4,625.00
3,000.00
8,772.65
8,897.52
4,396.27
129,038.99
187,326.59
6,000.00
55,884.24
4,408.50
1,670.80
2,500.00
1,081.91
51,900.00
261,278.50
1,815.00
53,000.00
5,000.00
84,920.00
5,012.17
112,902.98
35,451.03
5,000.00
28,667.96
1,750.00
426.03
200.00
15,875.00
21,654.51
34,843.75
3,612.50
5,178.50
10,000.00
49,375.00
216,835.00
200.00
200.00
2,711.55
3,356.40
54,891.56
20,320.96
9,764.54
7,348.65
300,000.00
1,209.00
7,486.00
4,328.50
12,890.00
3,855.50
5,356.00
2,164.64
33,400.00
32,000.00
69,263.32
11,366.03
3,709.38
1,502.00
1,583.12
10,558.59
3,098.00
12,631.13
7,419.74
3,769.49
129,038.99
8,413.10
30,000.00
3,437.50
-
2,800.00
1,145.92
1,785.00
31,619.23
200.00
1,416.10
115,920.00
4,906.01
4,247.00
23,287.11
5,000.00
50,000.00
54,000.00
7,000.00
8,437.00
5,674.00
33,549.07
12,422.68
3,302.90
6,500.00
179,226.59
8,100.00
16,030.00
2,295.00
713.20
7,210.66
139,223.70
200.00
9,311.70
4,902.75
5,933.00
9,000.00
4,250.00
30,000.00
32,148.86
11,464.27
3,800.00
95.84
3,750.00
75,820.80
31,185.00
8,000.00
2,500.00
3,798.38
2,500.00
129,038.99
30,000.00
1,174,500.00
500.00
200.00
10,000.00
1,400.00
2,500.00
5,000.00
30,000.00
1,750.00
657.20
4,936.45
4,325.00
4,375.00
625.00
5,000.00
4,666.64
1,710.00
529.50
2,952.25
3,985.00
5,565.00
23,887.58
31,242.92
12,789.24
7,427.89
7,534.99
7,324.72
5,620.62
51,285.83
4,325.00
200.00
700,000.00
500.00
70,000.00
47,250.00
30,000.00
1,801.37
5,020.99
32,000.00
1,850.00
7,121.92
3,878.00
600,000.00
500,000.00
634.50
59,240.00
30,529.31
11,366.03
17,634.66
4,250.00
1,078.00
1,626.74
8,976.00
3,709.30
2,000.00
760.48
2,305.00
2,552.00
4,428.00
4,600.00
3,296.60
11,698.20
42,750.00
31,691.77
3,000.00
6,000.00
34,500.00
4,656.00
3,520.94
2,073.63
50,000.00
6,194.00
10,000.00
3,975.69
15,000.00

<colgroup><col></colgroup><tbody>
</tbody>


Thank you very much~
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,214,978
Messages
6,122,545
Members
449,089
Latest member
davidcom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top