Return first non blank cell (cells have formulas that return blank)

Try this array formula**:

=INDEX(E7:E21,MATCH(TRUE,E7:E21<>"",0))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

If every cell is blank you'll get the #N/A error.

Try this user defined function

Please Login or Register  to view this content.

Open the VBA editor by hitting Alt F11.
Insert a new module with Insert - Module
Paste in the above function
Go back to the sheet by hitting Alt F11.

In a suitable cell, enter =FirstNonBlank(E7:E21)
Remember to save the workbook as a macro enabled workbook .xlsm