![]() |
#3
|
|||
|
|||
![]()
In case there is a column, which is never empty when there is anything entered into any other cell in same row:
Select the whole datarange, and from Home menu Sort & Filter. You get filter selection controls at top of datarange (in header row in case you had them, in 1st row of datarange otherwise); Set the filter condition for column where always must be some value to '(Blanks)'; Select all filtered rows (row numbers at left of worksheet are colored blue), and delete them. In case the is not such column (which must be always filled): At right your datarange, into next column enter the formula like =COUNTA(A1:X1), which counts not empty cells in row, and copy this formula down for whole datarange; Set Sort & Filter for datarange (the column with formula included); Set the filter condition for added column to 0, and delete all filtered rows; Delete the column with formula. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
lourid | Excel Programming | 5 | 03-15-2022 09:39 AM |
VBA - Deleting Rows (criteria based) | BobbyG | Project | 1 | 07-31-2017 08:55 AM |
![]() |
Noah14 | Excel Programming | 1 | 09-19-2014 11:46 PM |
Deleting rows & pushing them up causing issues | ep2002 | Excel | 2 | 08-29-2014 02:09 AM |
![]() |
joflow21 | Excel | 9 | 11-22-2013 12:10 PM |