Hi there

This probably is an easy one, but I couldn't find it out by myself.

I've got time series data in columns which can have various #N/A cells until the first value appears. I am searching for a formula which retrieves the

I know this following formula to search for the

There must be something similar to find the first value...?

Greets, D.

This probably is an easy one, but I couldn't find it out by myself.

I've got time series data in columns which can have various #N/A cells until the first value appears. I am searching for a formula which retrieves the

**first value appearing**in such a time series output list (column).I know this following formula to search for the

**last value**:Code:

=INDEX(M12:M500;MATCH(9.99999999999999E+307;M12:M500))

Greets, D.

## Comment