G
Guest
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.
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.