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
check the attachment On Wed, Feb 9, 2011 at 8:32 AM, danial mansoor wrote: > 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: $$Ex

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...@yahoo.com > To: e