View original (French)

Get the value of the first non-empty cell Excel

Solved
FONGBE -  

Hello, how can we retrieve the value of the first non-empty cell in a row?

I tried the following formula but Excel gives me a different name.

=index(c2:c15;match(true;index((c2:c15<>0);0);0))

Thank you.

3 answers

  1.  M-12

    Good evening,

    Test this by validating with the CTRL + SHIFT + Enter keys (array formula)

    =INDEX( C2:C15,MATCH(FALSE, ISBLANK(C2:C15),0))
    2
    1. via55

      Good evening

      You are looking for the first value of a row and your formula refers to a column C2:C15 so what exactly do you want?

      To find the 1st empty cell in row 3 for example, the formula is:

      =INDEX(3:3;MATCH(TRUE;INDEX(3:3>0;0);0))

      And to find the 1st empty cell in column F:

      =INDEX(F:F;MATCH(TRUE;INDEX(F:F>0;0);0))

      Regards

      Via

      0