View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RHD3 RHD3 is offline
external usenet poster
 
Posts: 5
Default skip every other row when copying formula

I would like to be able to skip every other row when copying a formula. If I
have data in column A for example, and I want to use a simple formula in
column B like "=a1"(in cell b1) and "=a2"(in cell b3) and "=a3"(in cell b5)
and so on. I have tried using the drag and fill but I end up missing cells.