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