| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to return values that equal set amount?
I have a string of dollar amounts and I am trying to see if there is a quick
way to find out what amounts will total a fixed number. For example, I have a number of cells, and I want to see what cells will total $500,000.00 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Possible to return values that equal set amount?
Hi T,
Try Harlan Grove's FindSums routine: http://tinyurl.com/5kvyrk --- Regards. Norman "tdub" wrote in message ... I have a string of dollar amounts and I am trying to see if there is a quick way to find out what amounts will total a fixed number. For example, I have a number of cells, and I want to see what cells will total $500,000.00 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Possible to return values that equal set amount?
I use Harlan Grove's code as posted by Norman but here is another
alternative... http://www.tushar-mehta.com/excel/te...olver_Template -- HTH... Jim Thomlinson "tdub" wrote: I have a string of dollar amounts and I am trying to see if there is a quick way to find out what amounts will total a fixed number. For example, I have a number of cells, and I want to see what cells will total $500,000.00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| The sum amount total does not equal the the individual cells. | Excel Discussion (Misc queries) | |||
| How to make a X amount equal $300,000 | Excel Discussion (Misc queries) | |||
| string values do not equal cells, then return msg | Excel Programming | |||
| I want a series of letters to equal a dollar amount? | Excel Discussion (Misc queries) | |||
| To find a combination of numbers that equal a set amount? | Excel Discussion (Misc queries) | |||
Linear Mode
