+ Reply to Thread
Results 1 to 8 of 8

Return row number of blank row

  1. #1
    Registered User
    Join Date
    04-29-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    6

    Return row number of blank row

    I have a set of spreadsheets and each one has a blank line somewhere in the middle area. I need a formula that I can place at the bottom of each spreadsheet that returns the row number of the blank row in each one. All help is very appreciated!

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Return row number of blank row

    Try something like this..

    Array Formula - Requires CTRL+SHIFT+ENTER
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Drag it down..


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Return row number of blank row

    Hello,

    In case you want to count the number of blank rows, you can use this formula
    Please Login or Register  to view this content.
    You will need to adjust A1:A11 to your real file (If you have 1000 rows for example, it will be A1:A1000)

    This is just a normal formula. It will count the number of blank cell in a column (If you place it on a column that must have a value, you can easily point out which row is blank). The downside is that if your cell has "" in it, it won't be counted as blank.
    Last edited by Lemice; 04-30-2013 at 01:33 AM. Reason: clarification
    (copy pasta from Ford)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools

    Regards,
    Lem

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Return row number of blank row

    Double Posted
    Last edited by :) Sixthsense :); 04-30-2013 at 01:43 AM.

  5. #5
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Return row number of blank row

    Double posted.
    Last edited by Lemice; 04-30-2013 at 02:49 AM.

  6. #6
    Registered User
    Join Date
    04-29-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Return row number of blank row

    I need the blank rows number. I do not need to count the blank row, I know there is only one; I just need to know its location.

  7. #7
    Registered User
    Join Date
    03-12-2013
    Location
    Viet Nam
    MS-Off Ver
    Excel 2003
    Posts
    25

    Re: Return row number of blank row

    If your date set A1:A100, have some blank cell in A1:A100.
    This formula return the blank rows number
    Please Login or Register  to view this content.
    Finish by: Ctrl + Shift + Enter (not enter) and Fill down
    This formula return the end of the blank row number in A1:A100
    Please Login or Register  to view this content.
    Hope to help you!

  8. #8
    Registered User
    Join Date
    04-29-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Return row number of blank row

    This worked! thank you so much!

+ 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