I don't fully understand your question, but you may want an absolute
reference (e.g. Change =A1 to be =$A$1 which means the formula never
changes when moved/copied), or don't sort the column containing the
formulas.
Clive


--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=535872