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.