Previous Topic Next Topic

Cell references in Excel formula's

Closed
Culla - Sep 23, 2009 at 01:41 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 23, 2009 at 10:33 PM
Hello,

I'm looking for a formula that will change the cell it refers to be a set increment. I need to repeat this a couple of times, by pulling the formula horizontally while the cell it refers to is further down in a column.

For example Cell A1 = B11, Cell B2=B22, Cell C2 = B33, D2 = B44 etc.
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 23, 2009 at 10:33 PM
I suppose you have some entries in B11,B22,B33 etc
now in A1 type or copy paste this formula

=INDIRECT("B"&11*ROW(A1))

copy A1 down.
do you get what you want. if so confirm

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses