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 formu...
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.