Error in formula?

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...

rows A and B ran complete 180,400 lines but row c stopped at line 3,025 and
just filled zeros in the rest of the way. I can not seem to figure out how to
fix this. Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error in formula? 4
What is the "--" (double dash) in MS Excel formula? 2
up and down array 7
OFFSET LOOKUP function in VBA? 9
reverse pasting rows with alternate blank cells 0
Help with formula 3
I'm trying to do a "count" function at the end of a dynamic pivot table 0
FIND ERROR PROBLEM 0

Top