I want target cells to move right-to-left as I drag formula left-to-right

[tbablue]

I have a row range A1:A100. In B1 I have a formula that looks at A100.

Ordinarily, when I drag the formula in B1 along the rest of the row $1:$1 the target cell would change similarly (assuming the target hasn't been made absolute) [A100, A101, A102, etc]. Is there a way - by formula - that will effectively move the target cell to the left instead of the right so that as I drag my formula in B1 along to populate the rest of row $1:$1 the target cells run as A100, A99, A98, etc.

Any assistance welcomed.

 

[Peter_SSs]

I have a row range A1:A100. In B1 I have a formula that looks at A100.

Ordinarily, when I drag the formula in B1 along the rest of the row $1:$1 the target cell would change similarly (assuming the target hasn't been made absolute) [A100, A101, A102, etc]. Is there a way - by formula - that will effectively move the target cell to the left instead of the right so that as I drag my formula in B1 along to populate the rest of row $1:$1 the target cells run as A100, A99, A98, etc.

Any assistance welcomed.

Perhaps you could clarify a little. You have referred to "a row range A1:A100". A1:A100 is part of a column and has no left or right orientation. What exactly do you have/want?

 

[tbablue]

Sorry Peter

Of course you are right - my error. My row range is actually A1:Z1. References to columns were my mistake.

I just wanted to know - If I have a formula in A2 thats looking at Z1, is there a way to make the target cell move right-to-left as I drag my formula across the row left-to-right.

Formula in A2 reads contents of Z1 - as I drag A2 into B2 it returns the contents of Y1 - C2 returns the contents of X1 - D2 returns the contents of W1, etc.

I hope this makes sense.

 

[Peter_SSs]

Here's a smaller example that should point you in the right direction. Formula in A2 copied across.

Excel Workbook
	A	B	C	D	E	F	G
1	a	b	c	d	e	f
2	f	e	d	c	b	a
Right to Left

 

[tbablue]

Thank You Peter.

Patience and expertise sincerely appreciated.