Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need help creating a function.
The goal is to parse formulas from cells A1 to A5 and find the values of each factor. Example: A1 - "A+B=CD" A2 - "C+D+E=A" *Notice the double digit in the first formula. In this example the macro needs to parse these two rows and find the values for A,B,C,D and E that satisfy the two formulas. The idea behind this function is to be able to type simple formulas in several rows and have the macro calculate whatever the different factors are that satisfy all the formulas. Any help would be appreciated on how to do this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Look up with 2 factors | Excel Worksheet Functions | |||
if senerios with 2 factors | Excel Discussion (Misc queries) | |||
more factors needed for an SP UDF | Excel Programming | |||
Multiply one value by many factors | Excel Worksheet Functions | |||
Seasonal factors | Excel Programming |