BeachLover wrote:
I have a list of about 30 numbers in individuals cells in a column that added
up to over 200,000. I need to find the numbers within the 30 numbers that
add up specifically to 109,484.60. What formula can I use?
No mere formula can accomplish this. If you read up on /combinations/, e.g.,
http://tutors4you.com/permutationcom...ontutorial.htm
You will find the number of combinations of values you need to test is
2^30 - 1 = 1,073,741,824
That's over 1 /billion/ combinations! You need code that can loop
through all the possibilities.
The link posted by Gord Dibben might help. Good Luck!