Sort as "reference column"

  • Thread starter Thread starter kingjeremy
  • Start date Start date
K

kingjeremy

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.
 
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
 
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.
 
Back
Top