Find and move rows with empty Cell
Closed
Nav
-
Jul 20, 2009 at 08:50 AM
jenni.g Posts 124 Registration date Tuesday November 18, 2008 Status Member Last seen February 2, 2010 - Jul 21, 2009 at 12:40 AM
jenni.g Posts 124 Registration date Tuesday November 18, 2008 Status Member Last seen February 2, 2010 - Jul 21, 2009 at 12:40 AM
Related:
- Find and move rows with empty Cell
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
- How to delete rows and columns in word - Guide
- Repeat rows in excel - Guide
- Cell phone codes - Guide
- Excel cell color formula - Guide
2 responses
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jul 20, 2009 at 11:07 PM
Jul 20, 2009 at 11:07 PM
Hello Nav
In the 21st column of row 1, type the formula =COUNTA(A1:A20) and copy it down to 1000 rows. The filter it to take all values not equal to 20. The press F5 >> Special >> select visible cells only >>Cut>>Paste
In the 21st column of row 1, type the formula =COUNTA(A1:A20) and copy it down to 1000 rows. The filter it to take all values not equal to 20. The press F5 >> Special >> select visible cells only >>Cut>>Paste
jenni.g
Posts
124
Registration date
Tuesday November 18, 2008
Status
Member
Last seen
February 2, 2010
33
Jul 21, 2009 at 12:40 AM
Jul 21, 2009 at 12:40 AM
Or there is another way, right click on the number of the row and cut it to paste in your other sheet...
