Get the value of the first non-empty cell Excel
Solved
FONGBE
Posted messages
156
Status
Membre
-
FONGBE Posted messages 156 Status Membre -
FONGBE Posted messages 156 Status Membre -
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 réponses
Good evening,
Test this by validating with the CTRL + SHIFT + Enter keys (array formula)
=INDEX( C2:C15,MATCH(FALSE, ISBLANK(C2:C15),0))
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