Try this:

=INDEX(K1:K100,MATCH(TRUE,(K1:K1000),0))

Note: Commit that array formula by holding down the [Ctrl][Shift] keys and
press [Enter].

Adjust range references to suit your situation.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"FIRSTROUNDKO via OfficeKB.com" wrote:

Hi,

how do I select the first positive value in collumn K from row 1 downwards?

Thanks in advance

Darren

--
Message posted via http://www.officekb.com