Results 1 to 9 of 9

Thread: Select Column and Identify First and Last non blank cell value per segment (Range between Blanks)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Sep 2017
    Posts
    5
    Rep Power
    0

    Select Column and Identify First and Last non blank cell value per segment (Range between Blanks)

    I have a column which begins at A1 and continues through A65535, within this the sequence of numbers begins 1 through what ever the next highest number is, until a blank or dashes appears and then it continues on to the next available number. The blank or dash interval vary. I need a way to identify the 1st and last non-blank cell value between each segment or separate into new columns and the variable is either a blank or a dash example:

    1
    2
    3
    4
    blank
    blank
    5
    6
    blank
    blank
    9
    blank
    10
    11
    12

    the result should be either:

    B1: 1-4
    B2: 5-6
    B3: 9
    B4: 10-12

    or

    column B
    1
    2
    3
    4

    column C
    5
    6

    column D
    9

    column E
    10
    11
    12

    etc...

    I would appreciate any assistance, I'm not an export, but can fumble through a formula or vba and/or a combination.
    Attached Files Attached Files

Similar Threads

  1. VBA Code To Run Through A Column And Email Blanks
    By hooper12345 in forum Excel Help
    Replies: 1
    Last Post: 02-08-2016, 10:25 AM
  2. Replies: 3
    Last Post: 02-20-2015, 07:03 PM
  3. Replies: 0
    Last Post: 12-24-2013, 01:36 PM
  4. Replies: 2
    Last Post: 09-24-2012, 11:19 PM
  5. Formula To Identify A Cell Has Duplicate Words
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 07-03-2011, 05:52 AM

Posting Permissions

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