Forum Discussion
Can microsoft do this? Calculation to select numbers out of list that equal a certain amount?
Ex. I have a list of 300 random numbers that are all represent dollar amounts.
I need a formula that will look at all 300 numbers and tell me which ones equal a given amount ($699.35).
So the formula would have to select only the cells with numbers that, once summed, equal $699.35.
Is this possible?
B
4 Replies
Hi Ben
I may have come up with a solution to this utilising GOAL SEEK and RANDBETWEEN to force the number 1 to be applied in a variety of combinations to hit the right items
- Having tested this idea out a little it's probably not a good solution for 300 items.
Hi Ben,
It depends on what do you mean under "tell me" and do you mean numbers which are "equal" to given amount or all combination of numbers in the list sum of which gives you the defined amount.
For example, if to show numbers in the list which are equal to given one you may use conditional formatting on the list to highlight such.
