Results 1 to 13 of 13

returns number of blank cells between values

Threaded View

  1. #8
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: returns number of blank cells between values

    So row 3 is in fact completely blank...

    The prior formula for B1 does what you want you just need to change the reference to B3 to be B4 - ie the first days records.

    EDIT: scrap that - no it doesn't - you need to change ISNUMBER test - revised below

    If you're inserting rows such that you can't use the reference B4 (ie will become B5 when a new row is physically inserted) then use INDEX instead, ie:

    B1:
    =LOOKUP(10^10,CHOOSE({1,2},COUNT($A:$A),MATCH(TRUE,INDEX(INDEX(B:B,4):INDEX(B:B,MATCH(10^10,$A:$A))<>"",0),0)-1))
    else if you prefer to keep B3 then subtract 2 rather than 1 from the result (to account for row 3 being ineligible)
    Last edited by DonkeyOte; 12-15-2009 at 07:11 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