Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using formulae in excel | Excel Worksheet Functions | |||
excel formulae | Excel Discussion (Misc queries) | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
Translate excel formulae | Excel Discussion (Misc queries) |