Forum Discussion
Solved
Excel Formula nth String
Have an excel file with a column that has an equation. Essentially, I want to see the newest payment (from the equation) in another column. Want to do the following in a column next to the previ...
You are working backwards.
Everyone else puts the numbers in column B and then puts the formula in C3:
=SUM(C$3:C3)Maybe that is what confuses Riny_van_Eekelen.
Try this:
=--SUBSTITUTE(FILTERXML("<y><z>"&SUBSTITUTE(FORMULATEXT(B3),"+","</z><z>")&"</z></y>","//z[last()]"),"=","")
Riny_van_Eekelen No. New approach in the .xlsx attachment. Column B has the equation (formula) and want Column C to automatically show the last entry from Column B.
For example,
B4 is =933.93+1396.76
C4 should automate as a value is added. So it will show $1,396.76.
The Test Function column is close but no cigar. Not even sure it is on the right path.
Ideas?
You are working backwards.
Everyone else puts the numbers in column B and then puts the formula in C3:
=SUM(C$3:C3)
Maybe that is what confuses Riny_van_Eekelen.
Try this:
=--SUBSTITUTE(FILTERXML("<y><z>"&SUBSTITUTE(FORMULATEXT(B3),"+","</z><z>")&"</z></y>","//z[last()]"),"=","")
- Detlef,
Thank you for your asssistance. The subbstitute fits perfectly. Can report, I have been employing this formula this am. It’s working. When finish my task I’ll report the full outcome next week.
Riny,
Thank you for your assistance and persistence. If not, for you no way we have Detlef chime in with his thoughts.
Guys...we teamed up well here:) Cooperation is a job well done. Awesome work!
Give update next week.
Scott