Hi starguy,

There is a simple way of doing it. (Only if your data is not big.
Other-wise the file would take a lot of time to open).

Open a new sheet.
Go to Cell "A1"
type "=" and link it to your data sheet at cell "A1"
check the last cell of your data sheet and copy your formula to for
that range in the new sheet.

Sam


--
sanskar
------------------------------------------------------------------------
sanskar's Profile: http://www.excelforum.com/member.php...o&userid=33682
View this thread: http://www.excelforum.com/showthread...hreadid=534911