Your data set is too large for this type of analysis. The number of possible
permiutations and combinations that will add up to a given number will be
staggering and the processing time will be measured in months...

For example in this list of 30 numbers.
85.89
53.27
2.97
7.00
80.70
33.91
60.62
10.28
44.61
42.28
6.74
96.54
93.79
29.29
49.43
39.03
63.34
22.82
69.89
49.47
76.24
52.15
40.29
55.69
58.80
22.52
91.93
20.39
34.65
45.26


There are 294 different combinations that add up to 275.35. With a list of
400 numbers the possibilites are massive.

If nikki manages to do some of the matching to cut the list size down then
it might be possible, but there will still be a very substantial amount of
manual labour required. Generally speaking your search list needs to be less
than 50 before the analysis becomes feasable.
--
HTH...

Jim Thomlinson


"Mike H" wrote:

Hi,

This is enormously difficult. I kept the link to a solution posted by Harlan
Grove which in my opinion FWIW is an awesome piece of coding. Note in the
comments at the top of the code you need to set the 2 references this is done
in VB editor using TOOLS|References.

http://www.microsoft.com/office/comm...664&sloc=en-us

Mike

"Nikki0195" wrote:

I have a LARGE spreadsheet of items that I am trying to reconcile for an
entire month range. The issue that I am having - the bank statement may show
one amount ($1,000), where the spreadsheet may have 4 random amounts that
equal $1,000. I need to be able to find the items that equal a specified
number without having to manually add up several amounts and hope for a
match. Any suggestions? I have tried Conditional Formatting, Conditional
Sum, and the Solver add-in. None of these will give me what I need -
considering that I have about 400 items in a month.

Thank you all so much for taking the time to read this!