Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello!
Can you please help me in solving following problem: Given is the amount (for example 56,67) and massive: (for example 45,6; -3,2; 11,07; 58) Exercise is to show the components of the sum, which perform given amount. In our example the answer is 1. - 45,6 3. - 11,07 Can You give me an algorithm (and VBA code) to solve this problem in general - Given is N numbers (negative and positive) and searched amount (negative or positive)? If You have questions about problem, please ask from me: Regards, Jüri. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding all elements in a database | Excel Discussion (Misc queries) | |||
question about SUM - how to sum each for elements | Excel Worksheet Functions | |||
XML elements in Excel | Excel Discussion (Misc queries) | |||
Protection elements | Excel Discussion (Misc queries) | |||
Finding duplicated elements in a list | Excel Discussion (Misc queries) |