HI,

I have a set of data, 37 columns in all. The first column is titled
'Reference'. This starts from 1 up to 1416, which represent each row.
The next reference number after 1416 starts from 2000 and continues to
increase.

I am sorting the data by different columns. The problem is that these
reference numbers (from 1 to 1416) are being corrupted. Many numbers
are repeated and the rest vanish. But in total there are still 1416.

I think the problem is somehow centred in the gap between 1416 and
2000!!!! I tried to change the format of these numbers and also
created formulas but it did not work out.

thanks for any suggestions

BR
Stefan


--
sfar007
------------------------------------------------------------------------
sfar007's Profile: http://www.excelforum.com/member.php...o&userid=35131
View this thread: http://www.excelforum.com/showthread...hreadid=556380