Stop formula from changing

[Rubber Beaked Woodpecker]

Everytime I insert a new column the following formula moves on one column so that

=IFERROR(@INDEX(2:2,AGGREGATE(14,6,COLUMN(2:2)/(2:2<>""),COLUMNS(A$2:$A$2))),"")

becomes

=IFERROR(@INDEX(2:2,AGGREGATE(14,6,COLUMN(2:2)/(2:2<>""),COLUMNS(B$2:$B$2))),"")

I would like the formula to stay as it was. I have tried using indirect with no joy looking for a little help please.

Thanks

RBW

 

[Peter_SSs]

What cell is this formula in?
Are you dragging this formula right/down/nowhere?

 

[Rubber Beaked Woodpecker]

Formula is in cell A102 and yes will be dragged down/right.

Thank you

RBW

 

[Peter_SSs]

Thanks. I'm having trouble imagining what you are starting with, where you are inserting columns, what data (if any) you are putting in those new columns, what new results you want and where etc.

Can you give us a few small samples with XL2BB that might demonstrate some of those things and provide new explanation in relation to the specific sample data provided? You can hide most of the rows between row 2 and row 102 before creating the XL2BB samples. Just leave a few rows at the top and a few rows at the bottom that shows what is/should be happening.