Re: copying down formula
Thank you Donkeyote. Your formula is very useful. It starts with the 10th row and continues in increments of 10 rows.
I now need to start with row 42 (i.e. not row 10) and increment by 10 rows.
So the result would display in c100: =c42; in c101: =c52; in c101: =c62.
I have tried to adjust your formula without success. Any further advice would be gratefully received.
John
The most logical for future amendment would be:
C100: =INDEX(C:C,42+10*(ROWS(C$100:C100)-1))
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Re: copying down formula
Thank you very much Donkeyote. That will save us so much time. You are a star.
John.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks