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?
Scott1417 Sorry, you have lost me. Have no clue what you are trying to achieve. Perhaps someone else.