PDA

View Full Version : Find values



Romulo Avila
02-07-2017, 09:31 AM
Good afternoon,
There is the possibility of a VBA formula or code so that I can find differences of values, as follows:
It was found a difference of 380.50, I need to find the values that add up to this result, below is an example, where you can verify that the value of 380.50 and the sum of the cells L9 + L12


Thanks for the support.

18274

SamT
02-07-2017, 01:25 PM
What if. . . two sets of cells add up to the difference?
Difference = 6. Cells are 2, 3, 3, 4

What if. . . different combinations add up to the difference?
Example: Difference = 5. Cells are 1, 2, 2, 3, 4 (four combinations.)

Romulo Avila
02-08-2017, 04:48 AM
Good Morning,
At first I will work with the possibility of the difference being the sum of up to three cells, would have as a formula or VBA mark or copy to other cells the values that possibly would reach the difference. That would help me find this difference.


Thank you

SamT
02-08-2017, 10:28 AM
If this is to find accounting/bookkeeping errors, Certified Accountants have several techniques and trick for that purpose.

Romulo Avila
02-08-2017, 11:30 AM
SamT,

Good afternoon,


It would not be accounting properly, it would be related to financial part.