Hi

Try this:
=OFFSET(A6,-1,0)

Andy.

"Lynne......" wrote in message
...
Hi
Just wondering if there is a formula like ... 'the cell alway equals the
one
above it' no matter where it is pasted to apart from
A3 = A2
because if i use this formula and if the row above is deleted it doesn't
adjust.