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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
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.
[TABLE="width: 377"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]1[/TD]
[TD]ALFORD, JIM*[/TD]
[TD]9[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ALFORD, RUTH*[/TD]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]ALMASI, CAROL*[/TD]
[TD]15[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]ALMASI, DENNIS*[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]BADGER, JIM*[/TD]
[TD]15[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]BADGER, LYN*[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]BEIERLE, BOB*[/TD]
[TD]8[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]BEIERLE, CAROLYN*[/TD]
[TD]17[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]BERGER, RHONDA*[/TD]
[TD]17[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]BERGER, TODD*[/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]BERGERON, LESLIE*[/TD]
[TD]7[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]BERGERON, MAURICE*[/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]BOBE, DONNA*[/TD]
[TD]17[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]BOBE, LARRY*[/TD]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Upvote
0
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 65,372
- Office Version
- 365
- Platform
- Windows
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 | ||||||||
Upvote
0
Yes that would work, thank you.
Upvote
0
Yes that would work, thanks.
Upvote
0
Similar threads
