ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Look for a certain type of formula... (https://www.excelbanter.com/excel-discussion-misc-queries/113722-look-certain-type-formula.html)

jimmy

Look for a certain type of formula...
 
Does a formula exist that can search through a list of numbers and tell you
if any certain combination, whether adding or subtracting numbers in that
list, will provide you with a target number. For instance, say I have a list
of 100 random number and I'm trying to see if any of them, if added or
subtracted with each other, can give me a final value of some other number
that I'm looking for. If you need clarification on what I'm trying to
achieve here, just let me know.

Thanks,



All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com