Copy the formula by dragging but down but calculate by going left
 

Hi,

If I enter the formula:
=$C$1-E75 and copy down by dragging the column will remain E and the rows will change to 76,77,78 etc.

I need the opposite so when I drag down the row remains 75 but the column changes to F, G, H ...

I hope that my request was clear.

If that is possible please let me know.

Thank you in advance.

Regards,
Frank Gashi
CUNY

Copy the formula by dragging but down but calculate by going left
 

Hi,

Am Thu, 13 Oct 2016 10:05:27 -0700 (PDT) schrieb F.G.:

If I enter the formula:
=$C$1-E75 and copy down by dragging the column will remain E and the rows will change to 76,77,78 etc.

I need the opposite so when I drag down the row remains 75 but the column changes to F, G, H ...

try:
=$C$1-INDEX($E$75:$XFD$75,,ROW(A1))


Regards
Claus B.
--
Windows10
Office 2016

Copy the formula by dragging but down but calculate by going left
 

On Thursday, October 13, 2016 at 1:28:35 PM UTC-4, Claus Busch wrote:
Hi,

Am Thu, 13 Oct 2016 10:05:27 -0700 (PDT) schrieb F.G.:

If I enter the formula:
=$C$1-E75 and copy down by dragging the column will remain E and the rows will change to 76,77,78 etc.

I need the opposite so when I drag down the row remains 75 but the column changes to F, G, H ...

try:
=$C$1-INDEX($E$75:$XFD$75,,ROW(A1))


Regards
Claus B.
--
Windows10
Office 2016

AMAZING,
It works, can you explain how the actual formula works.
Thanks much my friend.
Frank

Copy the formula by dragging but down but calculate by going left
 

Hi Frank,

Am Thu, 13 Oct 2016 10:54:39 -0700 (PDT) schrieb F.G.:

It works, can you explain how the actual formula works.

Row(A1) is the column of the INDEX and will be increased by one when you
copy the formula down.


Regards
Claus B.
--
Windows10
Office 2016