who can write Excel Formulae
I have an idea for an Excel Formula that I think could be a big help to any
Excel user that would need to do a reconciliation of any type.
My idea is to take a range of cells and then in the background run a
summation for every combination of cells within that range. The second part
of the formula would be a determined number, the out desired output of the
formula would be any combinations of the range that could be used to derive
the determined number.
The formula would look something like:
=possible(a1:a100,desired#) and the output could be the list of cells that
make up "desired#".
Does anyone know either how to write a formula that can do this or who one
can contact at Microsoft to request such a formula? As I said earlier, this
would be a great help to many in the accounting and bookkeeping field when
trying to reconcile an account.
|