How to sort by grouped rows

I have several groupings of rows and I wish to sort these groupings based on
the cell value in one cell in each grouping. How can this be done?

For example... rows 1 & 2 are grouped and rows 3 & 4 are grouped, if I wish
to sort these grouped rows by the cell value in C2 (= 6) in the first group
and cell value C4 (= 7) in the second group without changing the groupings,
how would I do this? The values in column C are equations, i.e., C1 = A1 + B1

A B C
1 2 2 4
2 3 8 11
3 1 2 3
4 3 4 7

Oops, C2 actually equals 11, not 6.

"Mike" wrote:

> I have several groupings of rows and I wish to sort these groupings based on
> the cell value in one cell in each grouping. How can this be done?
>
> For example... rows 1 & 2 are grouped and rows 3 & 4 are grouped, if I wish
> to sort these grouped rows by the cell value in C2 (= 6) in the first group
> and cell value C4 (= 7) in the second group without changing the groupings,
> how would I do this? The values in column C are equations, i.e., C1 = A1 + B1
>
> A B C
> 1 2 2 4
> 2 3 8 11
> 3 1 2 3
> 4 3 4 7

> I have several groupings of rows and I wish to sort these groupings
> based on the cell value in one cell in each grouping. How can this be
> done?
>
> For example... rows 1 & 2 are grouped and rows 3 & 4 are grouped, if I
> wish to sort these grouped rows by the cell value in C2 (= 11) in the
> first group and cell value C4 (= 7) in the second group without
> changing the groupings, how would I do this? The values in column C
> are equations, i.e., C1 = A1 + B1
>
> A B C
> 1 2 2 4
> 2 3 8 11
> 3 1 2 3
> 4 3 4 7

> Oops, C2 actually equals 11, not 6.

One way is to use D and E as helper columns. Put the following in D1 and
copy down:
=IF(MOD(ROW(),2)=0,C1,C2)

Put the following in E1 and copy down:
=ROW()

Then select everything and sort on column D then E.

You can hide the helpers before printing or disseminating the file.