Error in formula?

  • Thread starter Thread starter jason2444
  • Start date Start date
J

jason2444

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)
Click to expand...
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?
 
What formula did you enter in column C? In your post, you showed columns F,
G and H, but not column C.

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

Regards,
Fred.



Sorry you are correct it is pulling info from a,b,c
Click to expand...
but it was F and G that completed and H that stopped at 3,025
 
Sorry you are correct it is pulling info from a,b,c
but it was F and G that completed and H that stopped at 3,025
 
The formulas look good, so it must be the data.

The formulas following H3025 will reference C101 and following. What's in
those cells?

You could also check to ensure that recalculation is set to automatic.

Regards,
Fred.
 
Back
Top