Adjusting Auto-Fill Formulas by Varying References

Good morning everyone,

I have a large spreadsheet with thousands of rows and tons of columns. I need to alter how the auto-fill usually works. Instead of adding 1, I need it to add 10.

Please Login or Register  to view this content.

and next cells would be:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

So on and so forth.

Thanks!

Getting an invalid error. I tried adjusting the numbers since my formulas start on row three and it still didn't work for me. "There's a problem with this formula" error and asks me if I'm sure I am trying to put in a formula.

Try swapping the ; for a,
=IFERROR(INDEX(DockSheet!$D$1:$D$1000;match(3+10*(row()-1),$D$1:$D$1000,0)),"")

Err, thanks Fluff, I left that semi colon there

One of the joys of having the US separators, I don't have to remember to change them all.

It's because I'm using Xl under Ubuntu. No way to change the separators

I don't have that error any longer but now it is returning a blank instead of the delivery number. I tried playing around with and it looks like each section is working except the row_num part of the INDEX function. All the other parts seem to be giving me the expected value except this one returns #N/A. I will do some reading on the MATCH formula and see if I can understand it better but if anyone has something obvious I should check out, that would be swell too.

See if the first cell you enter the formula in is in row1. Otherwise you will have to adapt the formula.

I think I did a really bad job explaining it. I gave up and just made a very simplified version. Please take me out of my misery

I will adjust the column/row references as necessary on my huge file.

Thanks!

In A3 try

Formula:

Please Login or Register  to view this content.

Works like a charm, thank you very much!!

Spoke to soon. Stops working, once it goes over 100 in the (ROW(a100) part of the formula. So 101-1000s returns a blank. Any ideas?

NM, increasing the range past $1000 is what i needed to do.

You're welcome & thanks for the feedback

Absolutely!