Error in formula?

[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)

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?

 

[Fred Smith]

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]

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

but it was F and G that completed and H that stopped at 3,025

 

[jason2444]

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

 

[Fred Smith]

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.