Drag and fill question

[kwg881]

Hi, I am having a problem with Dragging and filling. I would like my cells to fill sequentially when I drag but I seem to have an issue.

In cell B1 and each row down I would like the equation to look like this over the next 100 cells
=A1+A3
=A2+A5
=A3+A7...and so on

But when I drag fill over the next 100 cells the autofill does
=A1+A3
=A2+A5
=A4+A7
=A5+A7
=A6+A9
=A7+A9

Why does the second value seem to double up and not go by the increment of 2 as I would like? Thank you for any insight. Hopefully an easy solution because this is acutally part of a quite large IF statement and it is driving me batty.

Kris.

 

[Jonmo1]

Hopefully an easy solution because this is acutally part of a quite large IF statement and it is driving me batty.

Kris.

You're best off posting your actual formula, and post a few examples of how you expect the references to change as you fill down.
Any solution provided for your simplified version will most likely not work for your real situation.
So we'll spend more time trying to "adjust" the simple solution to apply to your real situation.


It doesn't work because filling formulas can really only incriment references by 1 row or column at a time.
It's "Trying" to do it's best to do what it "thinks" you want..
But of course we know a computer can't "try" or "think" very well...

It just doesn't work that way.

 

[kwg881]

Oh no, Now there is pressure to show what I think is a long IF statement Just remember that I am no excel expert, thus all the what are probably simple questions I ask.

My actual equations are:

=IF(AND(B1>A1,Adresses!A1>65%,Names!B2>65%),"YES","")
=IF(AND(B2>A2,Adresses!A3>65%,Names!B4>65%),"YES","")
=IF(AND(B3>A3,Adresses!A5>65%,Names!B6>65%),"YES","")


I would like to drag fill over the next 100 or so cells with this pattern.

Thank you.

Kris.

 

[Jonmo1]

Try

=IF(AND(B1>A1,INDEX(Adresses!A:A,((ROWS(A$1:A1)-1)*2)+1)>65%,INDEX(Names!B:B,((ROWS(A$1:A1)-1)*2)+2)>65%),"YES","")

Don't change the A$1:A1 parts, it has nothing to do with your data.