| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to reference a cell one up and one back
I'm trying to do a roster pattern which involves each person doing the same
but one day out of phase with the previous person. Basically, I need to fill a cell with the value in the cell one columnback and one row up (or sometimes 3 up and 3 back). In this way I can roster all 19 people without retyping each line. I'm not quite sure how to manipulate cell references to do this. Please could someone advice me? many thanks IA |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how to reference a cell one up and one back
In B2 enter =OFFSET(B2,-1,-1) to return value from A1
Basics are =OFFSET(cellref,rowindex,columnindex) Negative indices are up and left................positive indices are down and right. See help on the OFFSET function for more info and examples. Gord Dibben MS Excel MVP On Thu, 27 Nov 2008 17:23:17 -0000, "merlin" wrote: I'm trying to do a roster pattern which involves each person doing the same but one day out of phase with the previous person. Basically, I need to fill a cell with the value in the cell one columnback and one row up (or sometimes 3 up and 3 back). In this way I can roster all 19 people without retyping each line. I'm not quite sure how to manipulate cell references to do this. Please could someone advice me? many thanks IA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I switch from 1,2,3... back to A,B,C... column reference na | Excel Discussion (Misc queries) | |||
| Find a value and count the rows back to the reference row. | Excel Worksheet Functions | |||
| How do you change Cell name reference from R[-2]C[-1] back to C2 | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Linear Mode
