+ Reply to Thread
Results 1 to 3 of 3

Formula for avg skip, max skip, longest out

  1. #1
    Forum Contributor
    Join Date
    01-21-2010
    Location
    Chicago,Illinois
    MS-Off Ver
    Excel 2019
    Posts
    206

    Formula for avg skip, max skip, longest out

    i have one number from 6- 12 in each row of Col A and I want to find out the avg skip, max skip, and longest out (currently) for each number. Thanks

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,380

    Re: Formula for avg skip, max skip, longest out

    It may just be me, but I have no idea what you are looking for here. What is "average skip", "maximum skip" and "longest out"?

    Can you post an example of the sort of data you have and what you want to get out of it.

    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    01-21-2010
    Location
    Chicago,Illinois
    MS-Off Ver
    Excel 2019
    Posts
    206

    Re: Formula for avg skip, max skip, longest out

    for instance,

    6
    8
    7
    6
    5
    6
    9
    8
    5
    6

    the avg skip for 6 is 2, the max skip is 3

    When I say skip I mean that the 6 is not there
    Last edited by Jordans121; 12-12-2010 at 05:23 PM.

+ 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