If you meant D3 then Offset(-1, 0)

But you could not use this on an entire column

D1 has no Offset(-1, 0)

So a range would be required like D2:D1000


Gord