software

I'm not sure if there's an answer to this one, but I've found myself often
times trying to reconcile accounts that have values going in and out.
However, they're not always a one-to-one wash. For instance, I might have a
positive 100 go into an account in January, a negative 62 in February and a
negative 38 in March, bringing the balance to zero. Only thing is that each
account is made up of about 100 rows, so it's not so easy to identify which
ones belong where. So, is there a formula that will search a column to see if
any accumulation will total a specific value? An example would be, search
column B for any combination of existing values that can arrive at the sum of
$7,146.87. Thanks in advance.

Hi,

I'll be interested to see if anyone comes back on this. A hundred cells
gives you a very large number of number of calculations to perform ...
someway beyond Excel/VBA I suspect.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Masterquot;Coreyquot; wrote:

gt; I'm not sure if there's an answer to this one, but I've found myself often
gt; times trying to reconcile accounts that have values going in and out.
gt; However, they're not always a one-to-one wash. For instance, I might have a
gt; positive 100 go into an account in January, a negative 62 in February and a
gt; negative 38 in March, bringing the balance to zero. Only thing is that each
gt; account is made up of about 100 rows, so it's not so easy to identify which
gt; ones belong where. So, is there a formula that will search a column to see if
gt; any accumulation will total a specific value? An example would be, search
gt; column B for any combination of existing values that can arrive at the sum of
gt; $7,146.87. Thanks in advance.

To read the latest exhaustive discussion on that topic, search the MS Excel
Worksheet Functions newsgroup for: quot;find sum in list of of numbersquot;

It's the thread with around 26 posts

Enjoy

***********
Regards,
Ron

XL2002, WinXP-Proquot;Coreyquot; wrote:

gt; I'm not sure if there's an answer to this one, but I've found myself often
gt; times trying to reconcile accounts that have values going in and out.
gt; However, they're not always a one-to-one wash. For instance, I might have a
gt; positive 100 go into an account in January, a negative 62 in February and a
gt; negative 38 in March, bringing the balance to zero. Only thing is that each
gt; account is made up of about 100 rows, so it's not so easy to identify which
gt; ones belong where. So, is there a formula that will search a column to see if
gt; any accumulation will total a specific value? An example would be, search
gt; column B for any combination of existing values that can arrive at the sum of
gt; $7,146.87. Thanks in advance.