LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using formulae in excel conroy Excel Worksheet Functions 4 January 10th 07 08:04 PM
excel formulae zemarko Excel Discussion (Misc queries) 1 August 3rd 05 05:41 PM
Searching TEXT in formulae, rather than results of formulae AndyE Excel Worksheet Functions 1 July 15th 05 10:57 AM
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? Daniel Excel Worksheet Functions 1 June 23rd 05 11:38 PM
Translate excel formulae Helen Excel Discussion (Misc queries) 3 June 16th 05 07:05 PM


All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"