View original (French)

Get the value of the first non-empty cell Excel

Solved
FONGBE Posted messages 156 Status Member -  
FONGBE Posted messages 156 Status Member -

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 Posted messages 1349 Status Member 285
     

    Good evening,

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

    =INDEX( C2:C15,MATCH(FALSE, ISBLANK(C2:C15),0))
    2
  2. via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     

    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
  3. FONGBE Posted messages 156 Status Member
     

    thank you it works

    0