+ Reply to Thread
Results 1 to 4 of 4

count the number of blank cells from the last entry

  1. #1
    Registered User
    Join Date
    07-11-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    2

    count the number of blank cells from the last entry

    Please read update on thread # 4 of this page.

    ------

    Hi this maybe kinda hard to explain but I'm attaching a sample to better explain it better.

    I need a formula that can tell me the number of blank cells between the last data and the end of a row.
    There may be some blanks in between data but only need to start count after the last entry.

    Please refer to the file.

    Thanks
    Attached Files Attached Files
    Last edited by Gerz; 07-12-2013 at 02:21 AM. Reason: update

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: count the number of blank cells from the last entry

    hi Gerz, welcome to the forum. in O2, try:
    =IFERROR(12-LOOKUP(2,1/(B2:M2<>""),COLUMN(B2:M2)-COLUMN(B2)+1),"never checked")

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: count the number of blank cells from the last entry

    Try This..

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  4. #4
    Registered User
    Join Date
    07-11-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: count the number of blank cells from the last entry

    Thanks, both Debra and benishiryo. I'm loving this place. They both worked and managed to incorporate them in my current work.

    Now though, I have a template in mind involving using a pivot to create a gantt chart. And would like to know how I can incorporate this lookup to it.
    Even gets trickier because it involves dates.

    Is it possible or would I need macro already?

    Sample template attached.
    Attached Files Attached Files

+ 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