View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Error in formula?

What formula did you enter in column C? In your post, you showed columns F,
G and H, but not column C.

Regards,
Fred.

"jason2444" wrote in message
...
ran this formula
In F1 enter
=OFFSET(A$1,(ROW()-1)/30,0)&" - "&OFFSET(D$1,MOD(ROW(D1)-1,30),)
In G1 enter
=OFFSET(B$1,(ROW()-1)/30,0)
in H1 enter
=OFFSET(C$1,(ROW()-1)/30,0)

Columns A&B completed 180,400 Lines But Column C stopped at line 3,025 and
filled in 0's the rest of the way down. Any ideas on how to fix this?