| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
|
|||
|
|||
find sum in list of of numbers
Look he
http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Kind regards, Niek Otten wrote in message oups.com... Wow, thank you so very much for all the responses. I've gone blind looking at these amounts over the past few days so I really appreciate the responses. First off, amongst some of my accountant co workers I know alot about excel but the VBE stuff is a bit shady for me. I've done some macros but the code Mr. Thomlinson provided is a bit out of my league. I'd need a more thorough explanation as to how to set up the code for me to make that work. I pasted it into VBE and turned on those options but I don't know what to do thereafter. I also want to try out the solver option but I need to have it installed. I'll have to try it at work tomorrow morning, man I really didn't expect all these responses this quickly, guess it helps posting in more than one group. For the record it seems that a few of the invoice amounts were missing from my list hence the huge problem with matching them up to payments. Even with that i still have some matching issues. I also forgot to mention that an invoice amount once used when matched to a payment cannot be used again. The combinations of course must match up to the payments to the penny. Again I really would like to try the VBE FindSum program but I'll need some newbie introduction into how to write a code like that and then how to use it. Thanks again! Dza the accountant |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find sum in list of of numbers | Excel Discussion (Misc queries) | |||
| find next number in list | Excel Discussion (Misc queries) | |||
| Find in a list | Excel Discussion (Misc queries) | |||
| Find the combination of numbers that when added equal a reqired total?? | Excel Worksheet Functions | |||
| How do I filter a number list by numbers to the right of the decim | Excel Worksheet Functions | |||
Threaded Mode
