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 Reference
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! -- Additional info about my computer: - Office XP - Windows XP Pro |
#2
|
|||
|
|||
Variable Cell Reference
Try the Offset function.
-b "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! -- Additional info about my computer: - Office XP - Windows XP Pro |
#3
|
|||
|
|||
Variable Cell Reference
Try the Offset function.
-b I have read the manual. But I'm not sure how this can answer the question. Would you mind explaining a bit more? -- Additional info about my computer: - Office XP - Windows XP Pro "bman342" ¦b¶l¥ó ¤¤¼¶¼g... Try the Offset function. -b "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! -- Additional info about my computer: - Office XP - Windows XP Pro |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to have a variable cell reference across sheets? | Shane Gibson | General Discussion | 3 | March 8th, 2006 10:10 PM |
Bring the cell format along with the cell value from a reference c | Lorrie Horgen | Worksheet Functions | 1 | January 20th, 2006 09:52 PM |
Allowing for variable cell reference in macro | tx12345 | Worksheet Functions | 2 | December 24th, 2005 04:50 AM |
Can you have fixed cell reference when dragging/copying formulae? | ducksfolly | General Discussion | 4 | December 20th, 2005 11:19 AM |
Using variable in cell reference | Meridiaman | General Discussion | 2 | July 10th, 2004 05:38 AM |