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.

Wow Alan, that was great, I resorted to just putting OFFSET(I$63,$H393,,1)
where $H393 and 394 and 395 increments by 13, but your formula is perfect, I
just changed the 16 to a 13 and the 800 to a 391 where the formula Starts.
You rock!

"Alan Beban" wrote:

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.

i'LL JUST TRY TO FIGURE OUT HOW TO CHANGE THE STRICTNESS OF THAT 800, i DONT
KNOW HOW INSERTING A ROW SOMEWHERE COULD CORRUPT THIS FORMULA. i'LL HAVE TO
TEST IT.

"Alan Beban" wrote:

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.

That is a good reason for not using ROW()

=OFFSET(I$63,16*(ROWS($A$1:A1)-1),)


can be put anywhere and it will not be affected if you delete or insert rows

I would also use INDEX instead of OFFSET since it's not volatile


Finally, don't use caps when posting, it is considered impolite




--
Regards,

Peo Sjoblom




"Javier Diaz" wrote in message
...
i'LL JUST TRY TO FIGURE OUT HOW TO CHANGE THE STRICTNESS OF THAT 800, i
DONT
KNOW HOW INSERTING A ROW SOMEWHERE COULD CORRUPT THIS FORMULA. i'LL HAVE
TO
TEST IT.

"Alan Beban" wrote:

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.