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 idea for XXX?
Thanks in advance,
Merci
Sylvain19 Not the most elegant, but this should work:
=VALUE(SUBSTITUTE(FORMULATEXT(B7),"=B",""))See attached in C8.
6 Replies
Sylvain19 The formula =ROW(A2), or =LIGNE(A2), in French will return the number 2. If this is not what you are asking, please upload an example workbook, rather that writing what each cell contains in words.
Sylvain19 Still don't get it.
Cell A4 contains a reference to A2. Just enter =ROW(A2) in B4 it will result in 2.
Or perhaps you want to find the row number of the cell that is equal to the value in A4? Then you could use MATCH. See attached.
