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
- If cell contains date then return value ✓ - Office Software Forum
- Conditional formatting if cell contains text - Excel Forum
- Insert the current date and time in cell a1 ✓ - Excel Forum
- Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
- An example of a cell is a blank cell ✓ - Programming 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...
