Do formulas in a table translate when sorted?

I have a table in excel that has formulas in the rows. When I sort the
table, the addresses in the formulas do not translate to the new location
after the sort. I am not using absolute addressing. This is confirmed
because the address do translate when I drag them to the next row. How can I
make the addresses translate after sorting?

Nothing built will take care of that, there are some workarounds here

http://www.mvps.org/dmcritchie/excel/offset.htm

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Matt@Major" <Matt@Major@discussions.microsoft.com> wrote in message
news:9C667CF2-FB14-4382-BA78-9944BCDEC019@microsoft.com...
>I have a table in excel that has formulas in the rows. When I sort the
> table, the addresses in the formulas do not translate to the new location
> after the sort. I am not using absolute addressing. This is confirmed
> because the address do translate when I drag them to the next row. How
> can I
> make the addresses translate after sorting?