“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

. I am trying to optimize my initial value of my recursive function. I know the best constraints and am trying to find the best Po that fits my data. my function is
Pn+1=1.927*Pn-.002219*Pn^2

Solved by F. L. in 24 mins

I'm trying to make a VBA function with two arrays; the first array has the numeric values while the second array has the names. The function will find the value in the first array that is the largest and return the corresponding name (from the second array).

Solved by D. Y. in 11 mins

I need a formula or combination of formulas to find a string within a larger string. For example
1 10
2 15
3 35
4 45
5 55
I'd want to find which cell the "0" is in, as if using the MATCH function but it needs to find the value within the larger string

Solved by A. A. in 24 mins

Use the VBA Editor to create a new module.
Function Depreciation (Value, Rate)
Depreciation = Value * Rate
End Function

Solved by G. S. in 30 mins

i need help with a formula that allows me to find the same value in another workbook then enter another value from the row it find the match. i know vlookup allows me to find the match but i dont know how to get the other value after it find the match.

Solved by B. H. in 30 mins