If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Variable Cell Referencing
Hi. I have forumlas which reference to a lot of cells, eg: =...A1, ...A1, ... A1+A$2-$A3... ....B1, ...B1, ...B1+B$2-$B3... .... ... .... ... Is it possible to do something like: =...A1, ...Same as left, ... Same as left + (SameButRowDown1) + (SameButRowDown2) ....SamebutColRight1, ... Same as left + (SameButRowDown1) + (SameButRowDown2) .... ... .... ... "Same as left" means the referencing is the same as the left cell reference. so for "=...$C$5, ...Same as left", it's equal to "=...$C$5, ...$C$5" "RowDown1" means switching the row down by 1, eg from A1 to A2. "ColRight1" means switching the column to the right by 1, eg from A1 to B1. Any workaround is acceptable. You may not need to do exactly the same. Thanks a lot! |
#2
|
|||
|
|||
Variable Cell Referencing
if a2 is to be same as left then the easiest way to do this is =A1 (as
A1 refers to another cell, both A1 and A2 would show the same value) For the rest, the OFFSET or INDIRECT functions would probably come to your aid, possibly with the use of ROW and/or COLUMN functions which would give you numeric values you can play with. 0-0 Wai Wai ^-^ wrote: Hi. I have forumlas which reference to a lot of cells, eg: =...A1, ...A1, ... A1+A$2-$A3... ...B1, ...B1, ...B1+B$2-$B3... ... ... ... ... Is it possible to do something like: =...A1, ...Same as left, ... Same as left + (SameButRowDown1) + (SameButRowDown2) ...SamebutColRight1, ... Same as left + (SameButRowDown1) + (SameButRowDown2) ... ... ... ... "Same as left" means the referencing is the same as the left cell reference. so for "=...$C$5, ...Same as left", it's equal to "=...$C$5, ...$C$5" "RowDown1" means switching the row down by 1, eg from A1 to A2. "ColRight1" means switching the column to the right by 1, eg from A1 to B1. Any workaround is acceptable. You may not need to do exactly the same. Thanks a lot! |
#3
|
|||
|
|||
Variable Cell Referencing
Not sure what you mean. could you mind giving an exmaple to illustrate? ??? ups.com ???... if a2 is to be same as left then the easiest way to do this is =A1 (as A1 refers to another cell, both A1 and A2 would show the same value) For the rest, the OFFSET or INDIRECT functions would probably come to your aid, possibly with the use of ROW and/or COLUMN functions which would give you numeric values you can play with. 0-0 Wai Wai ^-^ wrote: Hi. I have forumlas which reference to a lot of cells, eg: =...A1, ...A1, ... A1+A$2-$A3... ...B1, ...B1, ...B1+B$2-$B3... ... ... ... ... Is it possible to do something like: =...A1, ...Same as left, ... Same as left + (SameButRowDown1) + (SameButRowDown2) ...SamebutColRight1, ... Same as left + (SameButRowDown1) + (SameButRowDown2) ... ... ... ... "Same as left" means the referencing is the same as the left cell reference. so for "=...$C$5, ...Same as left", it's equal to "=...$C$5, ...$C$5" "RowDown1" means switching the row down by 1, eg from A1 to A2. "ColRight1" means switching the column to the right by 1, eg from A1 to B1. Any workaround is acceptable. You may not need to do exactly the same. Thanks a lot! |
#4
|
|||
|
|||
Variable Cell Referencing
=Indirect("A" & column(c2))
would give you the same result as =A3, but dragging it down would change NOTHING, dragging it across would mean that the next column would translate to =A4, then =A5 and so on =offset(a1,1,2) is the same as =C2 again, using column or row would enable you to change the value to be offset. 0-0 Wai Wai ^-^ wrote: Not sure what you mean. could you mind giving an exmaple to illustrate? ??? ups.com ???... if a2 is to be same as left then the easiest way to do this is =A1 (as A1 refers to another cell, both A1 and A2 would show the same value) For the rest, the OFFSET or INDIRECT functions would probably come to your aid, possibly with the use of ROW and/or COLUMN functions which would give you numeric values you can play with. 0-0 Wai Wai ^-^ wrote: Hi. I have forumlas which reference to a lot of cells, eg: =...A1, ...A1, ... A1+A$2-$A3... ...B1, ...B1, ...B1+B$2-$B3... ... ... ... ... Is it possible to do something like: =...A1, ...Same as left, ... Same as left + (SameButRowDown1) + (SameButRowDown2) ...SamebutColRight1, ... Same as left + (SameButRowDown1) + (SameButRowDown2) ... ... ... ... "Same as left" means the referencing is the same as the left cell reference. so for "=...$C$5, ...Same as left", it's equal to "=...$C$5, ...$C$5" "RowDown1" means switching the row down by 1, eg from A1 to A2. "ColRight1" means switching the column to the right by 1, eg from A1 to B1. Any workaround is acceptable. You may not need to do exactly the same. Thanks a lot! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with this conditional IF statement | C-Dawg | General Discussion | 3 | May 15th, 2006 06:01 PM |
Input cell reference is not valid (One Variable Data Table) | Dottore | Worksheet Functions | 9 | September 1st, 2005 03:05 PM |
how to create a variable column in cell reference | Sampson | Worksheet Functions | 3 | February 21st, 2005 10:13 PM |
GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |