Results 1 to 5 of 5

Excel 2007 : Counting consecutive blank cells for multiple rows from various starting points

Threaded View

  1. #1
    Registered User
    Join Date
    07-03-2012
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    2

    Counting consecutive blank cells for multiple rows from various starting points

    I have a series of data that includes months going across the columns and in the rows are accounts. The cells are populated with the amount of sales for each account during each month. I am trying to find a formula to quickly note which accounts have more than six month of inactivity or "0" sales. However, the catch is that I need the search to begin with the first month that each account begins its sales. For example, one account can have its data beginning in March and another account can have its sales start in June. I need the search of consecutive 0 value cells to start from each account's first month of sales. The formula should return a value, such as "0" for accounts that do not have 6 consecutive months of 0 sales at any point since their first month of sales or "1" for accounts that do have 6 consecutive months of 0 sales at any point since their first month of sales. I've included a sample attachment. Thanks!
    Attached Files Attached Files
    Last edited by JMcC421; 07-05-2012 at 08:19 AM.

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