Excel formula: Get first non-blank value in a list | Exceljet

exceljet.net

To get the first non-blank value (text or number) in a in a one-column range you can use an array formula based on the INDEX, MATCH, and ISBLANK …

View on exceljet.net