Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I import a large file which may have a few hundred rows.
in the rows there are the following Zero value cell, Blank cell and numerical cells I need to remove the cells that have a Zero value cell or are Blank. Only the numerical cell need to remain The starting cell is E7 So if E7 has a numerical value. move to E8 if numerical move to E9 etc. if however there is a blank space or a zero the row needs to be deleted. Your help greatly appriciated Thanks Gavin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula required | Excel Discussion (Misc queries) | |||
formula required | New Users to Excel | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula required | Excel Discussion (Misc queries) | |||
Help Required With IF AND Formula | Excel Worksheet Functions |