| 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 |
| 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 | |||
Threaded Mode
