Question description:
This user has given permission to use the problem statement for this
blog.
Hi i need a formula that will pick up 1 number that can be made up of a number of numbers in another column.
ie. in my column E i have a total of £2722.00 but a lot of number in column F and need to see if any combination of those numbers make up the £2722.00 thanks.
Solved by G. F. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
06/09/2018 - 10:44
Hu
Excelchat Expert
06/09/2018 - 10:44
Hi*
User
06/09/2018 - 10:45
Hi i am looking to see if there is a formula that can work out if the 2722 can be made up of the number on the side in column b
Excelchat Expert
06/09/2018 - 10:46
Got it
Excelchat Expert
06/09/2018 - 10:46
I am working on it
User
06/09/2018 - 10:46
is there a formula that highlights the numebrs that add up to the figure in column a
Excelchat Expert
06/09/2018 - 10:46
Give me some time
Excelchat Expert
06/09/2018 - 10:46
Please stay online and do not worry about the timer, you can extend it twice
Excelchat Expert
06/09/2018 - 11:02
[Uploaded an Excel file]
Excelchat Expert
06/09/2018 - 11:02
Hi
Excelchat Expert
06/09/2018 - 11:02
Here it is
Excelchat Expert
06/09/2018 - 11:02
In the sum to target sheet of this excel. I have done what you wanted
Excelchat Expert
06/09/2018 - 11:03
I will explain to you in steps
Excelchat Expert
06/09/2018 - 11:03
In column B you can paste your constituent numbers
Excelchat Expert
06/09/2018 - 11:04
In cell F1 and G1 you can enter your target value minimum and maximum
User
06/09/2018 - 11:05
okay thanks
Excelchat Expert
06/09/2018 - 11:07
In cell b1 enter the count of your constituent numbers
Excelchat Expert
06/09/2018 - 11:07
For example, in the online sheet you have given 8 numbers
Excelchat Expert
06/09/2018 - 11:08
So the cell B1 should read 8
User
06/09/2018 - 11:08
where do i put the 2722
Excelchat Expert
06/09/2018 - 11:09
G1
User
06/09/2018 - 11:09
and if f1?
Excelchat Expert
06/09/2018 - 11:09
F1 can be any number smaller to the target number
User
06/09/2018 - 11:09
do i leave this as 2722
Excelchat Expert
06/09/2018 - 11:09
Then you click on calculate button
Excelchat Expert
06/09/2018 - 11:10
Actually make F1 also as 2722
Excelchat Expert
06/09/2018 - 11:12
It will be better
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.