Sorting
 

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

Sorting
 

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

Sorting
 

I thought of this, but unfortunately, for reasons of statistics (how I have
to present them) two columns are required.

The firs one shows all the names according to a percentage, the second
colums contains all names, but different percentages (those with zero value
are ignored)
--
But never mind, I can always do it manually, sorting hence and forth....


Felix


"Dave Peterson" wrote:

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