+ Reply to Thread
Results 1 to 4 of 4

Removing rows which are empty

  1. 04-26-2015, 01:12 AM #1
    lovinguy
    lovinguy is offline
    Forum Contributor
    Join Date
    10-21-2010
    Location
    LONDON
    MS-Off Ver
    2007
    Posts
    108

    Removing rows which are empty

    Hi,

    I have a dataset in excel.I want remove rows which are blank.

    I have attached the sample sheet.Raw data is under "Data" tab and result is in "Output" tab.

    Thanks

    Loving
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-26-2015, 02:13 AM #2
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Removing rows which are empty

    Write in aditional column this formula:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    And extend it down.

    That will give you error if row is empty and some number if not.

    Then select that column, press F5 key Go To and choose Special...

    Select there Formulas with Errors:

    Untitled.jpg

    After OK only those cells will be selected.

    Right click on one of the selected cells and pres Delete...
    Choose Entire row
    and press OK.

    This will delete all of them so you can delete this column since it's not needed anymore.
    Reply With QuoteRegister To Reply
  3. 04-26-2015, 05:41 AM #3
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Removing rows which are empty

    If you want a macro, next one can help
    It does not give the same result as the OUTPUT but try



    Please Login or Register  to view this content.
    - Battle without fear gives no glory - Just try
    Reply With QuoteRegister To Reply
  4. 04-26-2015, 05:56 AM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,055

    Re: Removing rows which are empty

    Or, if youwant a formula and acting on Zbor's first step, try this Array Formula.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Drag across and down until blank rows appear. They're a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

    You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will get an error message or an incorrect answer. Press F2 on that cell and try again.

    Don't type the curly braces yourself - it won't work...
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Removing empty rows from a set of data - Need some help please!
    By mxoxossg in forum Excel General
    Replies: 4
    Last Post: 01-24-2013, 10:06 AM
  2. Removing empty rows
    By sentinela in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2010, 11:10 AM
  3. Removing empty rows with a macro
    By Mikie in forum Excel General
    Replies: 8
    Last Post: 10-12-2009, 06:15 PM
  4. Removing empty rows?
    By frenchman96 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-24-2007, 11:42 AM
  5. Removing Empty Rows and selecting Specific Rows
    By Jetheat in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-11-2005, 07:10 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1