| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =IF formula #NAME? error | Excel Worksheet Functions | |||
| Error in Formula | Excel Discussion (Misc queries) | |||
| How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
| Formula Error | Excel Worksheet Functions | |||
| Formula error | Excel Discussion (Misc queries) | |||
Hybrid Mode
