RE: Sorting 5 columns of data based on column A
- From: CAT <CAT@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 26 Sep 2008 15:29:00 -0700
Thank you for that, but it does mean copying and pasting right through in
column A, then sorting, then deleting it all again except for the first time
entry before copying the final sorted version to the workbook. Is there
another, quicker way?
Also, the alphabetical sorting of column D should be only applied to the
total of rows in each "time zone" but NOT to the overall column D. At the
moment, I highlight the block of 5 columns and sort Column D manually in each
section; Another quicker way?
I am trying to automate/speed up all of this as much as possible as I have
much more work to do on the worksheet later on. But thank you anyway for the
suggestion.
"JasonP CCTM LV" wrote:
For the sort to work properly, you would need each cell in column A to be.
filled if there is something on that row in the other columns.
MR1.35 3 72 London E Williams
MR1.35 2 600 Paris JG Given
MR1.35 1 33143 Sydney JJ Quinn
AS1.50 data data data data
AS1.50 data data data data
MR 2.35 data data data data
Once you have that done, then you would sort by column A then by Column D.
"CAT" wrote:
Hi everyone, hope someone can help me
(I am using Excell 2007, a fairly new user but getting better and better
everyday!)
What I would like to achieve:
I am downloading some data into a spreadsheet daily. Before I can copy it
into my workbook, I need to sort it:
1) Chronologically, by the data in column A, making sure that all the data
in the other 4 columns is linked - Column A only contains 1 row of data
(Time) but columns B, C, D and E can contain between 4 and 20 rows of data
and are linked to column A;
2) Within each "Time" section of column A, the data of column D
Alphabetically, whilst keeping the data in columns B, C and E linked to it.
Example:
Col A Col B Col C Col D Col E
MR 1.35 1 33143 Sydney JJ Quinn
2 600 Paris JG Given
3 72 London E Williams
etc...
MR 6.00
AS 1.50 data data data data
etc...
AS 6.30 data data data data
What it should look like after sorting:
MR1.35 3 72 London E Williams
2 600 Paris JG Given
1 33143 Sydney JJ Quinn
AS1.50 data data data data
data data data data
MR 2.35 data data data data
Etc...
What I am doing instead:
In trying the filter and sort function, all I get is a Sort on the first
column and none of the other columns get linked which is completely useless.
So I have to copy the first lot of chronologically sorted data into my
workbook, and then insert the other sets by copying and inserting blocks of
data in the appropriate time sequence slots which is all very time consuming
and can lead to errors.
Is there a way?
Many thanks in advance
- References:
- Sorting 5 columns of data based on column A
- From: CAT
- RE: Sorting 5 columns of data based on column A
- From: JasonP CCTM LV
- Sorting 5 columns of data based on column A
- Prev by Date: Re: Protecting and Unprotecting several worksheets at one time
- Next by Date: RE: Chart problem
- Previous by thread: RE: Sorting 5 columns of data based on column A
- Next by thread: Re: Sorting 5 columns of data based on column A
- Index(es):
Relevant Pages
|
