thanks!!!
From: danial mansoor
To: excel-macros@googlegroups.com
Sent: Wed, February 9, 2011 4:02:58 AM
Subject: RE: $$Excel-Macros$$ help pls : find first non empty row in range
use this formula with NOT ONLY PRESS ENTER,PRESS CONTROL+SHIFT+ENTER its an
thanks a lot!!! superb
From: ashish koul
To: excel-macros@googlegroups.com
Sent: Wed, February 9, 2011 5:33:44 AM
Subject: Re: $$Excel-Macros$$ help pls : find first non empty row in range
check the attachment
On Wed, Feb 9, 2011 at 8:32 AM, danial
, 8 Feb 2011 17:05:33 -0800
> > Subject: $$Excel-Macros$$ help pls : find first non empty row in range
> > From: lupins...@yahoo.com
> > To: excel-macros@googlegroups.com
>
> >
> > Hi All,
> > I hope you will help me in maybe something that is so simple, but I'
use this formula with NOT ONLY PRESS ENTER,PRESS CONTROL+SHIFT+ENTER its an
array formula it ll give u 7 answer.u
=MAX(IF(E17:E26>0,E17:E26))
> Date: Tue, 8 Feb 2011 17:05:33 -0800
> Subject: $$Excel-Macros$$ help pls : find first non empty row in range
> From: lupins...@ya
Hi All,
I hope you will help me in maybe something that is so simple, but I've
sent last 2 hours to sort it out without any conclusion. :(
The problem is: I need to find first cell that is bigger then 0 in the
specific range.
HELP!!!
PS I'd like to add an attachement but I don't know how, so e.g.: