Biff, thanks for detecting this

Correction to earlier formula ...
Put in E1:
=IF(A1="","",IF(COUNTIF($A$1:A1,A1)1,"",IF(ISNUMB ER(A1+0),A1+ROW()/10^10,IF(ISTEXT(A1),CODE(LEFT(A1))+ROW()*10^10))))

should instead be:
Put in E1:
=IF(A1="","",IF(COUNTIF($A$1:A1,A1)1,"",IF(ISNUMB ER(A1+0),A1+0,IF(ISTEXT(A1),CODE(LEFT(A1))*10^10+R OW()))))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Biff" wrote in message
...
This doesn't work on my sample file:

http://cjoint.com/?kmehWBQGic

Biff