As I am a lazy guy, I built this scheme :
The values which must be sorted aren't in the main table but in the auxiliary 'to_sort' one.
In the main table the corresponding values are grabbed in the column 'sorted' by the simple formula:
=OFFSET(to_sort :: $A$1,ROW()-1,0)
When I sort the to_sort table, the sorted values are automatically reported in the main table.
Yvan KOENIG (VALLAURIS, France) lundi 25 janvier 2010 16:15:39