Cell Referencing
This is a array formula.
You must enter it with Ctrl+****+Enter
instead of Enter
"Charabeuh" a écrit dans le message de
...
Perhaps ?
This example:
Put the formula in E11
=INDEX(E1:E10,MAX(IF(ISTEXT(E1:E10),ROW(E1:E10),0) ))
"Kris W" a écrit dans le message de
...
Is there a way to reference the nearest cell above the current cell that
has
text - distance is always going to be variable.
|