Hi William, I have included your both the examples in the solved workbook and attached that with this email. Please have a look. Further to this, what I have understood as per your query is "there are some numbers which will be generated randomly and at the end will be followed by some Zeros".. here I want to say that I have taken this criteria, no matter what happens in between in the list, but the CRUX here is that the random numbers are always going to be followed by some zeros and this is what I have considered, which ULTIMATELY solves your query.
Please let me know if you still face any challenges. You are always welcome on that. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Mon, Aug 24, 2009 at 8:24 PM, William <w...@cox.net> wrote: > Dilip: > > Thank you for responding. I think I need to better explain my issue. > > Column *A* may or may not start with 0's. In any case, the 0's will be > followed by a series of whole numbers and they will be followed by 0's > again. The following are two examples. > > > *A* *A* > 0 3 > 0 4 > 0 3 > 3 9 > 6 8 > 6 3 > 0 1 > 0 0 > 0 0 > 0 0 > > Your example shows column *A* starting with 0's, followed by whole > numbers, then 0's again, followed by whole numbers again and then followed > by 0's. This sequence cannot exist. > > Also, in your example, 0's should follow the first 1 in Column A and in > that case, 9 would appear in D1. That corresponds to the first time a 0 > appears in column *A* following a series of whole numbers. > > I hope this explains my issue little better. > > Thank you. > > Bill > > > > > > > > > ----- Original Message ----- > > *From:* Dilip Pandey <dilipan...@gmail.com> > *To:* William <w...@cox.net> > *Cc:* excel-macros@googlegroups.com > *Sent:* Monday, August 24, 2009 6:22 AM > *Subject:* Re: Fw: > > 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.3.xls
Description: MS-Excel spreadsheet
