Re: $$Excel-Macros$$ help pls : find first non empty row in range

2011-02-09 Thread pawel lupinski
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

Re: $$Excel-Macros$$ help pls : find first non empty row in range

2011-02-09 Thread pawel lupinski
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

Re: $$Excel-Macros$$ help pls : find first non empty row in range

2011-02-08 Thread ashish koul
, 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'

RE: $$Excel-Macros$$ help pls : find first non empty row in range

2011-02-08 Thread danial mansoor
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

$$Excel-Macros$$ help pls : find first non empty row in range

2011-02-08 Thread lupinskip
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.: