Results 1 to 21 of 21

Finding gaps within rows of numbers

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-31-2008
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    149

    Finding gaps within rows of numbers

    Hello,

    Please see attached.

    Via macro, I am trying to establish where there is a gap in numbers, signified by a "-". The 2 cases of this are E3 and E5. Note that B7 isn't gap because it is the first numer in the sequence. Nor is L6, as it is the last.

    I'd be grateful for some code to generate the TRUE and FALSE values in column A.

    Thanks in advance.
    Attached Files Attached Files
    Last edited by bd528; 01-24-2011 at 12:34 PM.

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