Sort as "reference column"
 

Column A has a random sorted list of text values, column D also consists
of same values but not in the way sorted as column A. What I want is to
sort Column D just like Column A but with the adjacent columns to the
right (Column E,F also) should sort together with column D.


--
kingjeremy
------------------------------------------------------------------------
kingjeremy's Profile: http://www.excelforum.com/member.php...o&userid=26444
View this thread: http://www.excelforum.com/showthread...hreadid=474882

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

thanks for this nice tip, I really like the idea of helper columns. But
considering this process being repeated many times like once in every
15-30 rows and it goes until something 2500 in row length, it seems
quite a lot of work. Still something like a formula would do a great
job.


--
kingjeremy
------------------------------------------------------------------------
kingjeremy's Profile: http://www.excelforum.com/member.php...o&userid=26444
View this thread: http://www.excelforum.com/showthread...hreadid=474882