sorting

[Lowggy]

I have a file with 40 plus couples with last names, first name in two consecutive rows of a column. I have another column that has a single value. The values for each couple ie two rows of a column is different. I want to sort the file keeping the couples together but sorted by the value of the other column.

 

[Peter_SSs]

Any chance we could have a smallish set of sample data and the expected results so that we are sure we know what we are dealing with?

 

[Lowggy]

Any chance we could have a smallish set of sample data and the expected results so that we are sure we know what we are dealing with?

Here is a small section of the file. I want to sort so that the couples with the last names are sorted by column E. Ie the Almasi's have the lowest value of 7 in column E so they should be first, followed by Bergeron's who also have 7 and then Beierle's. I thought I could just sort by column A and then E but I want to keep the last names together then sort by column E.

1	ALFORD, JIM*	9	24	9
1	ALFORD, RUTH*	15
2	ALMASI, CAROL*	15	22	7
2	ALMASI, DENNIS*	7
3	BADGER, JIM*	15	26	11
3	BADGER, LYN*	11
4	BEIERLE, BOB*	8	25	8
4	BEIERLE, CAROLYN*	17
5	BERGER, RHONDA*	17	33	16
5	BERGER, TODD*	16
6	BERGERON, LESLIE*	7	23	7
6	BERGERON, MAURICE*	16
7	BOBE, DONNA*	17	26	9
7	BOBE, LARRY*	9

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Peter_SSs]

Could you add another column with a formula like this, copied down, anf then sort using column F?

Excel Workbook
	A	B	C	D	E	F
1
2	1	ALFORD, JIM*	9	24	9	9
3	1	ALFORD, RUTH*	15			9
4	2	ALMASI, CAROL*	15	22	7	7
5	2	ALMASI, DENNIS*	7			7
6	3	BADGER, JIM*	15	26	11	11
7	3	BADGER, LYN*	11			11
8	4	BEIERLE, BOB*	8	25	8	8
9	4	BEIERLE, CAROLYN*	17			8
10	5	BERGER, RHONDA*	17	33	16	16
11	5	BERGER, TODD*	16			16
12	6	BERGERON, LESLIE*	7	23	7	7
13	6	BERGERON, MAURICE*	16			7
14	7	BOBE, DONNA*	17	26	9	9
15	7	BOBE, LARRY*	9			9
Sort

 

[Lowggy]

Could you add another column with a formula like this, copied down, anf then sort using column F?

Sort

	A	B	C	D	E	F
1
2	1	ALFORD, JIM*	9	24	9	9
3	1	ALFORD, RUTH*	15			9
4	2	ALMASI, CAROL*	15	22	7	7
5	2	ALMASI, DENNIS*	7			7
6	3	BADGER, JIM*	15	26	11	11
7	3	BADGER, LYN*	11			11
8	4	BEIERLE, BOB*	8	25	8	8
9	4	BEIERLE, CAROLYN*	17			8
10	5	BERGER, RHONDA*	17	33	16	16
11	5	BERGER, TODD*	16			16
12	6	BERGERON, LESLIE*	7	23	7	7
13	6	BERGERON, MAURICE*	16			7
14	7	BOBE, DONNA*	17	26	9	9
15	7	BOBE, LARRY*	9			9

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:26px;"><col style="width:177px;"><col style="width:33px;"><col style="width:33px;"><col style="width:33px;"><col style="width:33px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula F2 =IF(E2="",F1,E2) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Yes that would work, thank you.

 

[Lowggy]

Yes that would work, thank you.

Yes that would work, thanks.

 

[Peter_SSs]

You're welcome.