Posted to microsoft.public.excel.misc

jason2444

external usenet poster

Posts: 30

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)

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error formula	Lauravila	Excel Discussion (Misc queries)	1	June 29th 06 09:13 PM
Error in Formula	LaniG	Excel Discussion (Misc queries)	2	May 29th 06 09:54 PM
How do I replace "#N/A" error, to continue my formula w/o error?	Ali Khan	Excel Worksheet Functions	2	February 20th 06 03:49 PM
Formula Error	Mike R	Excel Discussion (Misc queries)	6	January 15th 05 05:27 AM
Formula Error	Cheri	Excel Discussion (Misc queries)	3	December 14th 04 12:01 AM

All times are GMT +1. The time now is 07:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us