![]() |
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? |
All times are GMT +1. The time now is 10:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com