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
Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
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
