+ Reply to Thread
Results 1 to 1 of 1

Counting blanks between values and reporting individually

  1. #1
    Registered User
    Join Date
    08-23-2012
    Location
    Aus
    MS-Off Ver
    Excel 2007
    Posts
    9

    Counting blanks between values and reporting individually

    I have a very large table representing operations at different times, scattered with numbers but populated mostly with blanks.
    It looks something like this,

    Please Login or Register  to view this content.
    I want to do some statistical analysis on the time between operations so I am hoping to produce a second table below the first that lists the number of blanks in each gap, sequentially for each column.
    Something like this,

    Please Login or Register  to view this content.

    I know what the maximum number of gaps is, but the number of gaps in each column varies.
    Can anyone think of a way to achieve this?
    Last edited by zilch42; 08-23-2012 at 11:13 PM. Reason: table didn't space correctly

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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