Error in formula?
 

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?

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?

Error in formula?
 

"Fred Smith" wrote:

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?

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

Error in formula?
 

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" wrote:

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?

Error in formula?
 

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.

"jason2444" wrote in message
...
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" wrote:

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?