Hi William, Apologies for the delay. Please find the attached solution.
Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Sun, Aug 23, 2009 at 2:50 AM, William <w...@cox.net> wrote: > > ----- Original Message ----- *From:* William <w...@cox.net> > *To:* dilipan...@yahoo.com > *Sent:* Saturday, August 22, 2009 2:17 PM > > Dilip: > > > > You were able to help me create a formula in Excel 2007 back around Aug. 1 > and it worked well. I was wondering if you could take a look at the > following to see if this can be solved. > > > > *A* *B* *C* *D* > > 0 7 0 9 > > 0 7 6 > > 7 8 5 > > 6 2 0 > > 4 7 6 > > 3 5 5 > > 1 0 7 > > 0 8 9 > > 0 4 8 > > 0 7 2 > > > > I have three columns of numbers. Column *A* will have a series of numbers > that *may or may not start* with 0’s. The 0’s will be followed by a series > of whole numbers (non-0 numbers). The whole numbers will then be followed by > 0’s. Again, remember that the whole numbers *may be preceded by 0’s or may > not*. In other words, cell A1, A2, etc. may have a 0 or may have a whole > number. The whole numbers will always be followed by 0’s. > > > > Columns *B* and *C* will have a random series of numbers. > > > > Each time a run a program (import data), the numbers in Column *A* will > change. The new series of numbers may or may not begin with a 0 but will > always end with a 0 or number of 0’s. The numbers in Column *B* will also > change but the numbers in Column *C* *will not change*. > > > > I would like to show in cell *D*1, the number in Column *C* that > corresponds to the first time a 0 will appear in column *A* following the > series of whole numbers. In the example above, 9 is the number in column > *C* that corresponds to the first time a 0 appears in column *A* following > the series of whole numbers. > > > > I need the formula for cell *D*1. > > > > Dilip, thanks for your help. > > > > Best Regards, > > > > Bill > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
Solution by DILipandey v1.2.xls
Description: MS-Excel spreadsheet
