+ Reply to Thread
Results 1 to 4 of 4

Excel Data: Return next result after a series of results

  1. #1
    Registered User
    Join Date
    10-30-2017
    Location
    Loughborough
    MS-Off Ver
    MS Office 365 Excel 2016
    Posts
    6

    Excel Data: Return next result after a series of results

    Hi clever excelites!

    I stumble through excel and generally find what I need through trial and error but, cannot seem to get my head around returning the next value after a series of events. I have doena search on patterns and series but, cannot seem to find what I am after.

    I have attached a basic table and briefly, I want to know what happens after there is a series of three 0s in column F.

    Further to this, I would like to be able to consider other IF scenarios, such as, only considering Column A; Bob and Column B; Sally with a series of three 0s (column F) returning the next number in Column G. In this example, I would be looking for G5: 1.64 ... but ultimately, I would like to be able to make a table of results based on a much larger dataset to be able to see if there are any patterns.

    Does this make sense?

    Many thanks in advance for any help!

    Excel Query.jpg

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,065

    Re: Excel Data: Return next result after a series of results

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Starting in row 4 will work for your initial issue
    Please do add reputation where you see fit, it's nice to be nice and we all enjoy a pat on the back

    Please also mark your thread as solved once it has been.

  3. #3
    Registered User
    Join Date
    10-30-2017
    Location
    Loughborough
    MS-Off Ver
    MS Office 365 Excel 2016
    Posts
    6

    Re: Excel Data: Return next result after a series of results

    Awesome, thanks .. I will play around with that. Did not think to total the 0s (Doh)!

  4. #4
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,065

    Re: Excel Data: Return next result after a series of results

    you're welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1