| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Reference with Range Name | Excel Worksheet Functions | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| Bring the cell format along with the cell value from a reference c | Excel Worksheet Functions | |||
| Getting contents of a cell when cell reference is in the sheet | Excel Discussion (Misc queries) | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Linear Mode
