Hi
One way would be to use helper columns. Start by adding a column before
or after column A, in that helper column enter the numbers 1,2,3....etc
to the last row, select both your columns and sort your text column
alphabetically, now insert another helper column before column D,
select columns D,E and F and sort again aphabetically, now copy and
paste the first helper column in the second helper column, then select
columns D,E and F along with your helper column and sort by the helper
column in ascending order, do the same with column A and its helper
column. When you delete your helper columns, column D should be the
same as column A.

Hope this helps!
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=474882