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