I need to produce the following result which lists subtotals. It looks straightforward but I am stuck:
cell c100: = c10
cell c101: = c20
cell c103: = c30
cell c104: = c40
What formula can I use in c101 to display the result in cell c20 and then copy down as required?
Thanks in advance from John in Kings Cross, London, UK.
Last edited by johnrat; 11-27-2009 at 10:52 AM.
John,
C100: =INDEX(C:C,10*ROWS(C$100:C100))
copied down
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 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))
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
johnrat 
Register To Reply
Bookmarks