When you copy down, XL will only change the relative row (if possible). If
you want to copy down, but want to change columns, perhaps this will work:

=INDIRECT("R3C"&ROW(A1),FALSE)

This currently refers to A3. Copying down will change the row in formula to
A2, causing overall formula to reference B3.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Luzma" wrote:

I want to copy a formula that has a relative column and an absolute row A$3
but when I try to copy it down the column doesn't change it copies the same
A$3 and I want B$3 C$3 etc.. Can someone help me? Thanks!!