I have and excel file with about 200 rows. Consecutive columns have cells with last name, first name but in between those pairs of couple there are single names. I want to sort the file in alphabetical order keeping all the couples together and listing the single names at the end and of course keeping all the other columns in tact.
-
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.
Excel Facts
Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
sandy666
Banned - Rules violations
- Joined
- Oct 24, 2015
- Messages
- 7,497
I think:
- start new thread
- start title with: VBA - describe in short the problem eg. random four-person teams from two-person groups with condition
- describe detailed what you have and what you want
- post a link to the excel file (as you did here) with raw data and example what you want to achieve
- start new thread
- start title with: VBA - describe in short the problem eg. random four-person teams from two-person groups with condition
- describe detailed what you have and what you want
- post a link to the excel file (as you did here) with raw data and example what you want to achieve
Last edited:
Upvote
0
Similar threads
- Solved
