0

If have texts in column A, with empty cells In B20, I 'd like to get the row number of the first non empty cell above A20, without VBA.

I found some examples with "LOOKUP" function but I get "DIV/0" error. Perharps because I have text and not numbers in column A ?

Could you help me please ?

John DT
  • 7
  • 1
  • 5

1 Answers1

0

You can use this:

=MATCH(TRUE,INDEX(ISBLANK($A20:$A1048576),0,0),0)

BruceWayne
  • 22,923
  • 15
  • 65
  • 110
  • Thanks for your answer but this give me the first empty cell from top to bottom. I 'd like to find the first non empty cell from bottom to top. In column A I have rows 1 to 5 with text, row 6 emtpy, rows 7 to 18 with text, row 19 and 20 empty, rows 21 to 30 with text. In B20, if I 'd like to get the text that is in A18 (first cell with text from bottom to top). – John DT Feb 15 '17 at 19:28