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:
There must be something similar to find the first value...?Code:=INDEX(M12:M500;MATCH(9.99999999999999E+307;M12:M500))
Thanks for the reply!
The formula works, but the problem with it is that I need to define an array with the same length as the data (column), so with time series data i get a few hundred cells in my array, all with the value of the first cell..
Is there any way I can eliminate this problem, with having a non-array formula only in one cell?
There are currently 1 users browsing this thread. (0 members and 1 guests)