View Single Post
  #1   Report Post  
Kevin
 
Posts: n/a
Default offset and clear

Hi
I have a worksheet that contains daily data
i fill column A with a formula which is the index for the data.
what i want to do is check column B for <"" (this means an index
number assigned) i then want to clear the contents of column A below
the last record
in column B

thanks

kevin