find first non error value in a column

Giganews Newsgroups
Subject: find first non error value in a column
Posted by:  Mika (rigel_…@yahoo.com)
Date: 13 Jan 2007

Hi,

I have column filled either with #N/A or a number. I need a formula to
"extract" the first numeric value in that column.
example:

#N/A
#N/A
#N/A
15
#N/A
#N/A
3
#N/A
the answer must be 15.

Thanks for your time.
Mika

Replies