Need Formula

[jasgow]

Hi, I am trying to get a formula to find out the non empty cell value out of few empty cells. For your reference i am attaching a file. Please check it and let me know the answer.

[FJCC]

Try

Code: Select all

=INDEX(C4:C14;MATCH(".+";C4:C14;0))

For this to work, you have to go to the menu Tools -> Options, expand the Calc list on the left, select Calculate and select Enable Regular Expressions in Formulas.

[Lupp]

(Just for completeness.)
===Edit 2018-09-21 09:36 CEST: I was wrong about the LibO release containing the fixed version. Now correct.===
===Edit 2018-09-21 10:51 CEST: If interested in more detail, see the attached demo.===

In LibreOffice since V5.2 (partly working), completely fixed with about V 5.4.4 V5.3.3.2 there is a fucntion allowing a different approach by a slightly simpler formula:

Code: Select all

=TEXTJOIN("";0;C4:C14)

(TEXTJOIN is not yet specified in OpenFormula.)