i want to sort data

it is inthe format where i would like to have 3 rows considerd as 1
unit and depending on the highest value in one column they must be
sorted the three rows in itself as well as the entire three sets

an example

col a b c
12345
1 2 3
4 5 6
7 8 9


24567
4 6 4
and it continues
in set of three(rows) in col a b and c


and i am interested in sorting in EXCEL by say column c and want all
three values to be displayed infront of the 12345 no that is the first
row that is empty after the col value.

also once i have sorted the values, i want to make a different sheet
which has all the max values in each row set and sort them too

please can anybody help me with the same

Hi
You probably need to redesign your sheet first. What is it about each
block of three rows that groups them together? If they are all fruit of
one type, for example, then put that with them

e.g.
col a b c d

1 2 3 apple
4 5 6 apple
7 8 9 apple
4 6 4 orange
and it continues...

DO NOT have any blank rows in your data. Now you can sort by column d
to keep the rows of three together and sort by other columns as a
second criterion.

regards
Paul


wrote:
i want to sort data

it is inthe format where i would like to have 3 rows considerd as 1
unit and depending on the highest value in one column they must be
sorted the three rows in itself as well as the entire three sets

an example

col a b c
12345
1 2 3
4 5 6
7 8 9


24567
4 6 4
and it continues
in set of three(rows) in col a b and c


and i am interested in sorting in EXCEL by say column c and want all
three values to be displayed infront of the 12345 no that is the first
row that is empty after the col value.

also once i have sorted the values, i want to make a different sheet
which has all the max values in each row set and sort them too

please can anybody help me with the same

yes paul this is a simplified answer
but the thing is i dont want to keep deleting the blank row that i get
as an output to another file cause that will mean large work
cause i have atleast 15 pages of data per analysis

and also i want the col to stick together like a b c d are all values
releating to the value in col the one that is blank in rest of the
page.


regards
indraneel

PS does any one have a example of VBA of a do while loop i want it for
reference thank you




wrote:
Hi
You probably need to redesign your sheet first. What is it about each
block of three rows that groups them together? If they are all fruit of
one type, for example, then put that with them

e.g.
col a b c d

1 2 3 apple
4 5 6 apple
7 8 9 apple
4 6 4 orange
and it continues...

DO NOT have any blank rows in your data. Now you can sort by column d
to keep the rows of three together and sort by other columns as a
second criterion.

regards
Paul


wrote:
i want to sort data

it is inthe format where i would like to have 3 rows considerd as 1
unit and depending on the highest value in one column they must be
sorted the three rows in itself as well as the entire three sets

an example

col a b c
12345
1 2 3
4 5 6
7 8 9


24567
4 6 4
and it continues
in set of three(rows) in col a b and c


and i am interested in sorting in EXCEL by say column c and want all
three values to be displayed infront of the 12345 no that is the first
row that is empty after the col value.

also once i have sorted the values, i want to make a different sheet
which has all the max values in each row set and sort them too

please can anybody help me with the same