thanks a lot!!! superb
________________________________ From: ashish koul <koul.ash...@gmail.com> 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 mansoor <danial_...@hotmail.com> 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: $$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'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.: >> >> column X >> 0 >> 0 >> 0 >> 0 >> 7 >> 6 >> 7 >> 0 >> 0 >> 0 >> >> -- >>---------------------------------------------------------------------------------- >>- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >>http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com/ >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com/ >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/ >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel > >-- >---------------------------------------------------------------------------------- > >Some important links for excel users: >1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip >2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >3. Excel tutorials at http://www.excel-macros.blogspot.com >4. Learn VBA Macros at http://www.quickvba.blogspot.com >5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >To post to this group, send email to excel-macros@googlegroups.com > ><><><><><><><><><><><><><><><><><><><><><><> >Like our page on facebook , Just follow below link >http://www.facebook.com/discussexcel > -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile PBefore printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel ____________________________________________________________________________________ The fish are biting. Get more visitors on your site using Yahoo! Search Marketing. http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
