Results 1 to 9 of 9

Thread: excel - count consecutive values

Threaded View

  1. Jan 30th, 2009, 10:47 AM #1
    italian_guy
    italian_guy is offline

    Thread Starter
    Lively Member
    Join Date
    Dec 2007
    Posts
    94

    excel - count consecutive values

    Hi guys. I have a great problem to solve and I can't find a solution.

    I make an example

    A B C D E F G H I J
    1 2 3 6 7 8 11 12 13 14



    i need to calculate how many consecutive numbers there are

    OCCURRENCES
    3 4 5 6 7 8 9 10 (consecutive numbers)

    2 1 (count of consecutive numbers)



    In this example I need to have as results 2 for 3 numbers (1,2,3 and 6,7,8) and 1 for 4 numbers (11,12,13,14)

    Is there sum array formula that i can use or it occurs vba?
    Thanks in advance.
    Last edited by italian_guy; Jan 30th, 2009 at 11:01 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width