+ Reply to Thread
Results 1 to 4 of 4

Count columns between spaces

  1. #1
    Registered User
    Join Date
    06-30-2014
    Location
    UK
    MS-Off Ver
    Windows 7
    Posts
    2

    Count columns between spaces

    So say I have 3 sections of data seperated by a blank row like this:
    Text
    Text
    -blank-
    Text
    Text
    Text
    -blank-
    Text

    I want to count how many rows are in each section (which are seperated by blank rows):
    The output should be in 3 different cells like so:
    2
    3
    1

    I'm really stuck on how to do this, the closest I've come is the following which can only count the first section of data:
    =MIN(IF(C:C="",ROW(C:C)))-ROW(C1)

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Count columns between spaces

    Cross-post:

    http://www.mrexcel.com/forum/excel-q...en-spaces.html
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Registered User
    Join Date
    06-30-2014
    Location
    UK
    MS-Off Ver
    Windows 7
    Posts
    2

    Re: Count columns between spaces

    I wasn't aware asking on different forums would reach the same people! Thankyou for your answer - I'm trying to figure out how it works atm

  4. #4
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Count columns between spaces

    You're welcome, though you should make sure you reply in that forum so that other readers are aware that it's solved.

    Regards

+ 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. Formula To Add Spaces Until Character Count Is 10
    By JonnyBoy333 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-18-2012, 04:10 PM
  2. Word count with spaces
    By iamreese in forum Word Formatting & General
    Replies: 2
    Last Post: 11-16-2011, 06:54 AM
  3. LOOKUP won't count blank spaces
    By aphid in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-29-2007, 05:55 PM
  4. Count how many certain word appears with spaces
    By micko_escalade in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-23-2007, 01:56 AM
  5. Count spaces in front of text
    By poppy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-07-2006, 02:24 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