Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Enter in Cell I800
=OFFSET(I$63,16*(ROW()-800),0) and fill down. Alan Beban Javier Diaz wrote: Hello everyone, this is something I could just say = A1 then A=17 then A so and so. But why, when I could use an offset formula, but jeezz louise, I cant get it to work. I need a formula in I800to look at I63 bring back the data, then on I801 to bring back I79 then on I802 to bring back I95. How can I do this guys and gals. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
OFFSET function in named range returning wrong # of rows | Excel Worksheet Functions | |||
Offset | Excel Worksheet Functions | |||
Offset Help | Excel Worksheet Functions | |||
creating columns with data from offset rows | Excel Discussion (Misc queries) | |||
Max Offset | Excel Discussion (Misc queries) |