+ Reply to Thread
Results 1 to 3 of 3

Consecutive Numbers

  1. #1
    Registered User
    Join Date
    06-08-2018
    Location
    India
    MS-Off Ver
    2016
    Posts
    1

    Consecutive Numbers

    In an example attached 1 represent outage/Absenteeism so in order to find consecutive number like 1 after 1 , twice or thrice . Kindly help
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Consecutive Numbers

    So, what is the question? And why are some cells highlighted Yellow? Some are just below another 1 but some are isolated by itself. i.e. B153, G155.

    What is the logic you are looking for and do you want a summary or just conditional formatting?
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,110

    Re: Consecutive Numbers

    Use this as a New Rule, Use Formula...
    =AND(B2=1,C2=1)

    It will highlight (I used red), each time 2 or more cells contain a 1. It wont highlight the last 1 in the sequence, but will still show the sequence.
    IE if 2 1's, 1st will be highlighted
    if 3 1's 1st 2 will be red etc
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 09-15-2017, 05:30 AM
  2. Finding 5 consecutive numbers in a set of 7 numbers
    By Namejs in forum Excel General
    Replies: 13
    Last Post: 05-20-2015, 06:35 AM
  3. How to get MIN and MAX of Consecutive Numbers
    By Livmi in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-12-2015, 02:04 PM
  4. Replies: 6
    Last Post: 03-23-2012, 06:03 PM
  5. Excel 2007 : Consecutive Numbers Over 110
    By hbrugler in forum Excel General
    Replies: 1
    Last Post: 06-16-2011, 01:41 PM
  6. Excel macro to "fill in" consecutive numbers in non-consecutive list?
    By Tomkat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2009, 01:13 PM
  7. consecutive numbers
    By Monique in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-07-2005, 02:06 AM

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