Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet protection with grouped rows? | Excel Worksheet Functions | |||
How do I sort rows with hyperlinks? | Excel Discussion (Misc queries) | |||
Numbering of Grouped Rows | Excel Discussion (Misc queries) | |||
How to use outline data (grouped rows) in a protected worksheet? | Excel Discussion (Misc queries) | |||
Why have I got some repeating rows after a Excel 2003 sort | Excel Discussion (Misc queries) |