Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers sum to a specific amount
For example: I have about 10 different dollar amounts and I want to see if
there is any combination of those numbers that total to a specific dollar amount. For example if i had the following numbers in colum A; $1.20, $3.25, $5.90, $6.00, $0.46, ect.. and I wanted excel to tell me if there is any combination of numbers that add up to exactly $6.46. Is that possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers sum to a specific amount
Hi
Have a look he http://tinyurl.com/r8xkv Hope this helps. Andy. "Bentley26" wrote in message ... For example: I have about 10 different dollar amounts and I want to see if there is any combination of those numbers that total to a specific dollar amount. For example if i had the following numbers in colum A; $1.20, $3.25, $5.90, $6.00, $0.46, ect.. and I wanted excel to tell me if there is any combination of numbers that add up to exactly $6.46. Is that possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers sum to a specific amount
Please post all the possible numbers, and I'll let you know how many
combinations add to 6.46. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers sum to a specific amount
Here is a link to a VBA solution that worked for me:
http://www.microsoft.com/office/comm...398&sloc=en-us HTH "Bentley26" wrote: For example: I have about 10 different dollar amounts and I want to see if there is any combination of those numbers that total to a specific dollar amount. For example if i had the following numbers in colum A; $1.20, $3.25, $5.90, $6.00, $0.46, ect.. and I wanted excel to tell me if there is any combination of numbers that add up to exactly $6.46. Is that possible? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers sum to a specific amount
THANK YOU!!!!!!!
"Dominic LeVasseur" wrote: Here is a link to a VBA solution that worked for me: http://www.microsoft.com/office/comm...398&sloc=en-us HTH "Bentley26" wrote: For example: I have about 10 different dollar amounts and I want to see if there is any combination of those numbers that total to a specific dollar amount. For example if i had the following numbers in colum A; $1.20, $3.25, $5.90, $6.00, $0.46, ect.. and I wanted excel to tell me if there is any combination of numbers that add up to exactly $6.46. Is that possible? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers sum to a specific amount
Thank Harlan. <g
You're welcome. Glad it helped. Thanks for the feedback. "Bentley26" wrote: THANK YOU!!!!!!! "Dominic LeVasseur" wrote: Here is a link to a VBA solution that worked for me: http://www.microsoft.com/office/comm...398&sloc=en-us HTH "Bentley26" wrote: For example: I have about 10 different dollar amounts and I want to see if there is any combination of those numbers that total to a specific dollar amount. For example if i had the following numbers in colum A; $1.20, $3.25, $5.90, $6.00, $0.46, ect.. and I wanted excel to tell me if there is any combination of numbers that add up to exactly $6.46. Is that possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sum numbers thru specifying the amount from another cell? | Excel Discussion (Misc queries) | |||
Can you round numbers to display a specific set of numbers, for e. | Excel Discussion (Misc queries) | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
To find a combination of numbers that equal a set amount? | Excel Discussion (Misc queries) |