Results 1 to 5 of 5

Thread: *Resolved* Determining Longest Run of Consecutive Numbers

Threaded View

  1. Apr 1st, 2005, 01:51 PM #1
    TheRobster
    TheRobster is offline

    Thread Starter
    Hyperactive Member
    Join Date
    May 2004
    Location
    Right here
    Posts
    275

    *Resolved* Determining Longest Run of Consecutive Numbers

    Hi all,

    How would I get Excel to determine the longest 'run' of a given number in a list of numbers? E.g. suppose I have the following data in column A:

    24
    34
    0
    12
    0
    0
    67
    54
    0
    0
    0
    99

    Now suppose I want Excel to look at that data and tell me what the longest consecutive run of zero's are. In this case it would be 3 zero's. But how does I do this?

    Thanks
    -Rob
    Last edited by TheRobster; Apr 5th, 2005 at 10:44 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