Results 1 to 10 of 14

Thread: Delete All Empty Cells From Range Using VBA / Remove Blank Cells Using Formula

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 06-09-2013, 09:38 PM #9
    mahmoud-lee
    mahmoud-lee is offline
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0
    YES
    YOU MEAN LIKE THIS
    {=IF(ISERROR(INDEX(A$3:A$23;SMALL(IF(LEN(A$3:A$23) ;ROW (INDIRECT("1:"&ROWS(A$3:A$23)));"");ROW(A2))));""; INDEX(A$3:A$23;SMALL(IF(LEN(A$3:A$23);ROW (INDIRECT("1:"&ROWS(A$3:A$23)));"");ROW(A2))))}
    Last edited by mahmoud-lee; 06-09-2013 at 09:41 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Delete Entire Row For All Empty Cells In Column
    By johnreid7477 in forum Excel Help
    Replies: 4
    Last Post: 06-15-2013, 05:50 AM
  2. Copy cells from Sheet2, paste to next blank row in Sheet1
    By marreco in forum Excel Help
    Replies: 2
    Last Post: 02-11-2013, 08:13 PM
  3. Remove Entire Row of Blank Cells in Column, Autofilter non-empty non-blank cells
    By sanmaya in forum Excel Help
    Replies: 2
    Last Post: 09-24-2012, 11:19 PM
  4. Highlighting Blank Cells
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 08-13-2012, 07:56 AM
  5. Checking if range of cells=VbNullstring
    By Rasm in forum Excel Help
    Replies: 2
    Last Post: 02-03-2012, 07:24 AM

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