You may not like this, but you'll be better off dropping the duplicated names in
column D and just sort all the columns in the range (at least A:F in your
example) by the key that you like.

Felix wrote:

I have a column (say A1 to A20) with names that are sorted in a certain way
(alpha or acoording to values in a seperate column, say C) In another column
(say D1 to D20) are the same names, sorted also in a certain way (alpha or
acoording to values in a seperate column, say F)

I would like to have the same names in the same lines which is no problem
when both are sorted alphabetically, but what when the first group (A:C) is
sorted according to C? How do I get the names of the second group (D:F)
aligned with the names of the first?
--
Felix

--

Dave Peterson