in a columnGet to first positive value

's Computer Specifications

A formula delivers a result 0 or 1 in certain conditions in all the cells in
a coluumn.

I need to start scanning from row 1 to bypass the initial 0 value cells to
reach the first positive value in the column.

How do I do it?

's Computer Specifications

=INDEX(L1:L20,MIN(IF(L1:L20>0,ROW(L1:L20))))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"a m spock" <(E-Mail Removed)> wrote in message
news:7751C10E-9D56-4F4C-B2FD-(E-Mail Removed)...
>A formula delivers a result 0 or 1 in certain conditions in all the cells
>in
> a coluumn.
>
> I need to start scanning from row 1 to bypass the initial 0 value cells to
> reach the first positive value in the column.
>
> How do I do it?
>

's Computer Specifications

Dont forget to array enter using ctrl+shift +enter

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"a m spock" <(E-Mail Removed)> wrote in message
news:7751C10E-9D56-4F4C-B2FD-(E-Mail Removed)...
>A formula delivers a result 0 or 1 in certain conditions in all the cells
>in
> a coluumn.
>
> I need to start scanning from row 1 to bypass the initial 0 value cells to
> reach the first positive value in the column.
>
> How do I do it?
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Subtracting positive amts from negative and positive from positive	bwbmom	Microsoft Excel Worksheet Functions	3	12th Feb 2010 03:15 PM
First Positive	David Vincent-Jones	Microsoft Excel Discussion	4	11th Sep 2006 01:28 PM
Formula to make Negative Values Positive & Positive Values Negative?	mustard	Microsoft Excel Misc	4	26th Sep 2005 10:05 PM
bit positive!!!???	RHY	Spyware Announcements	0	5th May 2005 10:43 AM
something positive on SP2	Patty	Windows XP General	4	5th Oct 2004 09:39 PM