View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gavin[_11_] Gavin[_11_] is offline
external usenet poster
 
Posts: 1
Default Help required on a formula

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