Forum Discussion
Solved
Afficher le n° de ligne de la référence d'une cellule
Hi, My problem: A1 = 10 A2 = 20 A3 =A1+A2 A4 =A2 --> display 20 I would like to display in B4 the row number of the cell reference in A4 I would like something like B4 = LINE(XXX(A4))=2 any ...
Sylvain19 Not the most elegant, but this should work:
=VALUE(SUBSTITUTE(FORMULATEXT(B7),"=B",""))See attached in C8.
Sylvain19 Not the most elegant, but this should work:
=VALUE(SUBSTITUTE(FORMULATEXT(B7),"=B",""))See attached in C8.
- Thanks a lot for your big help.
Function Formulatext (formuletexte in French) is a very good idea.
It works with all rows, I try this :
=STXT(FORMULETEXTE(B7);3;99)
Have a nice week-end,