| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting blank cells
i have a spreadsheet about 11 columns wide and 10,000rows down.
i want to delete all rows that have columns H, I AND J blank. IF any one column out of the 3 are blank i do not want the row to be deleted. The row is deleted only when the Columns H, I and J are blank in the same row. please advise |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting blank cells globally | Excel Discussion (Misc queries) | |||
| Deleting spaces in blank cells | Excel Discussion (Misc queries) | |||
| Deleting blank spaces in cells | Excel Discussion (Misc queries) | |||
| Deleting blank cells in a column | Excel Discussion (Misc queries) | |||
| Deleting rows with blank cells | Excel Worksheet Functions | |||
Threaded Mode
