Sort problem

N

Ntisch

Hi - I have a spreadsheet that I would like to sort

In column A - I have dates (in descending order)
In columns B, C, D, E, F - I have names (in no order).

What I am looking for is a sort command that sorts columns B through
in either ascending or descending order, whilst still keeping column
as the reference column? Ie after sorting columns B through F the
still correctly reference column A (the date they originally referre
to)?

thank
 
F

Frank Kabel

Hi
not very sure how you want to sort columns B:F. Normally it should be
sufficient to simply select the entire data range 8including column A)
and use 'Data - sort'. Maybe you can post (in plain text - no
attachment please) an example of your data and describe the expected
result
 
R

RagDyeR

Do you possibly wish to sort columns B,C,D,E, and F *row by row*?

If that's the case,
You *can't* do it "en masse".

XL allows left to right (row) sorts, *but* this will sort *only* one row at
a time.

It's really no different from doing a regular sort of columns.

There, you sort *one* column, and "drag" the other columns along, to retain
their relationship.
It's exactly the same when sorting rows.

If I understand what you're looking for, you wish to sort *individual* rows
into alphabetical order.

You'll have to do that row by row using,
<Data> <Sort> <Options>,
Click in "Sort Left To Right", then <OK>.

Your only other option would be to use code.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================




Hi - I have a spreadsheet that I would like to sort

In column A - I have dates (in descending order)
In columns B, C, D, E, F - I have names (in no order).

What I am looking for is a sort command that sorts columns B through F
in either ascending or descending order, whilst still keeping column A
as the reference column? Ie after sorting columns B through F they
still correctly reference column A (the date they originally referred
to)?

thanks
 
Top