branconfused
New member
- Joined
- Aug 17, 2018
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Location
- Calgary, AB
- Excel Version(s)
- Microsoft Office Pro 2016
I have a list of 78 numbers and 5 of those numbers add up to X but there is no indication as to which ones. How do i create a formula to find which set of 5 numbers adds up to my X exactly?
Out of this list - what numbers add up to 202223.29 exactly?? (these numbers are part of a bank statement which for some reason split the total but gave no indication which numbers were used)
Out of this list - what numbers add up to 202223.29 exactly?? (these numbers are part of a bank statement which for some reason split the total but gave no indication which numbers were used)
4897.05 | 8339.63 | 170.1 | 388.83 | 16427.25 |
55.13 | 18446.41 | 33075 | 3808.88 | 40469.63 |
8471.4 | 38354.21 | 1218 | 4358.55 | 76699.36 |
37578 | 3675 | 1368.47 | 49.35 | 5853.75 |
23079 | 6562.51 | 11838.77 | 30517.73 | 895.13 |
10084.3 | 8290.95 | 5139.8 | 2590.88 | 26.1 |
15686.55 | 6205.55 | 7062.65 | 2007.61 | 21897.2 |
28307.09 | 10459.22 | 554.81 | 588 | 19027.06 |
1046.64 | 28161 | 53494.88 | 6745.82 | 35356.13 |
10531.5 | 2334.68 | 28664.47 | 19691.91 | 2469.25 |
28521.67 | 945 | 34599.16 | 199023.84 | 3274.95 |
3171 | 21695 | 170415.83 | 9940.89 | 4303.95 |
9028.48 | 672 | 141.75 | 17364.91 | 12920.28 |
1134 | 6510.17 | 3628.8 | 235.2 | 4865.46 |
9955.73 | 5059.59 | 1050 | 14988.39 | 9855 |
8979.97 | 96382.54 | 4593.75 |