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
- Based on the cell values in cells b77 ✓ - Excel Forum
- Which example represents cell data with the date format applied to it? - Excel Forum
- How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
- Excel function question - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
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...
