• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto Increment Formula

dparteka

dparteka

Member
Cell A1 has the following in it… =Sheet2!C7, I’m looking for a formula for the cells below A1 that will automatically increment seven cells down, something like this…

A1 =Sheet2!C7
A2 =Sheet2!C14
A3 =Sheet2!C21
A4 =Sheet2!C28 and so on to A2100

Any help is greatly appreciated… thank you
 
SM... I should have provided a better explanation, your formula works good but not if I use it for other cells. The formula that is in Sheet3 Column A works because it is looking first at C7 in Sheet2 and then incrementing down 7. What do I do for the formula in Sheet3 column B which will be looking at C6 in Sheet2 and then also incrementing down 7... thank you for your time
 
SM... awesome, that's the ticket, you've been a great help. If you would be so kind, there is just one more thing and then I'll leave you alone. Can you show me how I can incorporate your formula with the one below?

=RIGHT(Sheet2!C1,6)
 
@dparteka

You can use it directly inside RIGHT function in place of text, as shown below:

=RIGHT(INDIRECT("Sheet2!C"&((6*(ROWS($B$2:B2)))+ROWS($B$2:B2)-1)),6)

Regards,
 
SM... once again you've saved the day, you are making me look pretty smart on this end, only wish I was... thanks again
 
You must log in or register to reply here.
Back
Top