Use formula to find potential sum out of a group of numbers

[Tosborn]

Hey Mr. Excelers,

I work at a bank. Very often I need to find a variance (specified value) out of a large range of numbers. Say for example I have a bunch of transactions:

[TABLE="width: 87"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]110.00
[/TD]
[/TR]
[TR]
[TD="align: right"]250.00
[/TD]
[/TR]
[TR]
[TD="align: right"]156,875.00
[/TD]
[/TR]
[TR]
[TD="align: right"]2.00[/TD]
[/TR]
[TR]
[TD="align: right"]5,566.27[/TD]
[/TR]
[TR]
[TD="align: right"]69.80[/TD]
[/TR]
[TR]
[TD="align: right"]15,000.00[/TD]
[/TR]
[TR]
[TD="align: right"]189,987.00[/TD]
[/TR]
[TR]
[TD="align: right"]58,999.00[/TD]
[/TR]
[TR]
[TD="align: right"]68.77[/TD]
[/TR]
</tbody>[/TABLE]

I need to find out if I can sum any of these numbers to get 249,054.77.

In this case it is easy as I know it is the last 3 numbers that add up to make 249,054.77. That is, 189,987.00 + 58,999.00 + 68.77 = 249,054.77. Therefore I can make 249,054.77 by a simple =sum(A8:A10)

However, when reconciling large accounts sometimes this list is much larger and it is often a large task to find out which of the number will equal our desired value. Is there a formula (possibly macro) that can tell me that the three numbers to make up 249,054.77 are located in cells A8, A9 & A10?

Many thanks,

Tim

 

[wideboydixon]

Phew! Sanity restored. Brain size restored to planet proportions

WBD