+ Reply to Thread
Results 1 to 3 of 3

Counting consecutive blank cells?

  1. #1
    Registered User
    Join Date
    11-21-2008
    Location
    Los Angeles
    Posts
    1

    Counting consecutive blank cells?

    I need to count consecutive blank cells in between nonblank cells. For example:

    Column A:
    H
    (blank)
    (blank)
    A
    (blank)
    V

    I need the cell next to "A" to return the number 2 because there are two blank cells in between A and "H", the next nonblank cell (counting upwards).

    So the cell next to "V" must return the number 1 because there is only one blank cell in between V and the next nonblank cell, going up.

    Please help. I tried a couple CountIf and IFBLANK formulas with no success.

    Thanks a lot,

    Ryan

  2. #2
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626
    I think this is what you need
    A3=A
    A5=V
    Please Login or Register  to view this content.
    *Press Ctrl + Shift + Enter.

    Copy down
    I need your support to add reputations if my solution works.


  3. #3
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    With your list starting in A2, then in B2:

    Please Login or Register  to view this content.
    Confirmed with CTRL+SHIFT+ENTER not just ENTER... you will see { } brackets appear...

    Then copy down.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

+ Reply to Thread

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