Hi,

I hope someone can help me.

I'm trying to write a formula where one value is incremented automatically when clicking and dragging, while the other values don't change.

For example:

A$1/(A$2-1)
A$1/(A$2-2)
A$1/(A$2-3)
etc.

Cheers,

Bill