# Increment Row inside offset function

1. ## Increment Row inside offset function

Hello folks. I have a formula like this in B6

=OFFSET(RAW!\$C9,,ROWS(B\$6:C6)-1)

What I want is to increment the reference RAW!\$C9 to add 90 so it would be reference RAW!\$C99 in C6, RAW!\$C189 in D6 and so on. How to do it while inside the OFFSET formula since I'm using it to get the data from RAW sheet?

Example (I did this manually)

from
1.PNG

to
2.PNG

2. ## Re: Increment Row inside offset function

i think this is what your trying to do
Formula:
`Please Login or Register  to view this content.`

3. ## Re: Increment Row inside offset function

Hello. I wish to retain ,,ROWS(B\$6:C6)-1 since i used it to transpose the data in RAW from column to row. Can i make it so in the next date it would be RAW!\$C\$99?

4. ## Re: Increment Row inside offset function

at a lost to what you are trying to achieve with that

Syntax
=OFFSET (reference, rows, cols, [height], [width])

rows to increase
(ROW(A1)-1)*90 = 9,99,189,etc

you had the next bit in columns
this ROWS(B\$6:C6)-1
Just moves the starting column right every row
0,1,2,etc

so the sequence your grabbing is C9,D99,E189,etc (single cells)
is this what you want?

or are you after areas?
C9, C9:C99, C9:C189

5. ## Re: Increment Row inside offset function

oh sorry i noticed you want to go across

use column instead of row to increment

Formula:
`Please Login or Register  to view this content.`

6. ## Re: Increment Row inside offset function

Sorry if I make it confusing to you. But what I want is this:

from

Attachment 663222

to

Attachment 663223

I want to make the reference which is RAW!\$C\$9 increment to make it RAW!\$C\$99 , 1RAW!\$C\$189 and so on, in the OFFSET function.

7. ## Re: Increment Row inside offset function

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

8. ## Re: Increment Row inside offset function

are you sure you know what ROWS(B\$6:C6)-1 is actually doing
with just offset by itself...its adjusting the height of your array size as you go down

so in row 6 it is 0
row 7 = 1
row 8 = 2
etc

best do as Pepe suggest are post spreadsheet to avoid further confusion

9. ## Re: Increment Row inside offset function

Originally Posted by humdingaling
i think this is what your trying to do
Formula:
`Please Login or Register  to view this content.`
This is a great help! Thank you so much!

There are currently 1 users browsing this thread. (0 members and 1 guests)