Search : in
By :

Cell references in Excel formula's

Last answer on Sep 24, 2009 3:33:17 am BST Culla, on Sep 23, 2009 6:41:00 pm BST 
 Report this message to moderators

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.

Best answers for « Cell references in Excel formula's » in :
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply

1

 venkat1926, on Sep 24, 2009 3:33:17 am BST

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

   
Reply to venkat1926
Ask your question Reply
They need your help