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