Incremental value in formula

[N0t Y0urs]

Is there a simple solution to this:

I want to run this formula down 100 entries with one small catch =input!e5

I don’t want the next line to be 6 but rather 10

I have 500 rows of data but only want to report every 5 row and don’t want to manually enter the data if I can avoid it.

Thanks in advance

 

[Fluff]

What cell is the formula in?

 

[N0t Y0urs]

What cell is the formula in?

I will ultimately have in 400 different columns

But I am trying to see if I can get the offset function to work.

So on a separate page I currently have =offset(acc!$b$5(row()-1)*5,0) and that’s located at overview!b20

It hasn’t returned the correct value but it’s done what I needed by incrementing. It has returned a value of 110 instead of 5

 

[N0t Y0urs]

I will ultimately have in 400 different columns

But I am trying to see if I can get the offset function to work.

So on a separate page I currently have =offset(acc!$b$5(row()-1)*5,0) and that’s located at overview!b20

It hasn’t returned the correct value but it’s done what I needed by incrementing. It has returned a value of 110 instead of 5

I figured it out I think.

I removed all the useless information and my formula now reads

=offset(acc!$b$4)5,0)

Then I’ve copied it down and it’s not incrementing

 

[Fluff]

Ok, how about

=INDEX(acc!$H$5:$H$5000,(ROWS(B$20:B20)-1)*5+1)

 

[N0t Y0urs]

Ok, how about

=INDEX(acc!$H$5:$H$5000,(ROWS(B$20:B20)-1)*5+1)

Nope that didn’t work. I’ve linked the sheet I’m working on

Master.xlsx

docs.google.com

 

[Fluff]

In what way didn't it work?

 

[N0t Y0urs]

In what way didn't it work?

I adjusted the reference points and it returned a value of 1 but I am trying to work it backwards to a solution

 

[Fluff]

That does not answer my question.

 

[N0t Y0urs]

Returning the Value if 1 in the first line then returning 6 is not what I require. My first value should be 5 then 10, 15 etc what you suggested gives me 1,6,11,16 etc

That does not answer my question.