OilEconomist
Active Member
- Joined
- Dec 26, 2016
- Messages
- 421
- Office Version
- 2019
- Platform
- Windows
Thanks in advance for you assistance.
I have a set of data that I am trying to sort by four criteria in the following order:
(1) By distance
(2) Name
(3) Gender
(4) Yes or No
The issue is that some of the names are repeated so there is no way to group them together if one of the other columns like Distance is different. Take this small example, I would like to sort by Distance and name. Initially I have this:
Finally I would like this:
But there is no way to do this with sort because if you sort by distance, you could not group all the Ron Smith's together.
Any ideas? Please note the data size I am using is much larger (like 150+ rows)
I have a set of data that I am trying to sort by four criteria in the following order:
(1) By distance
(2) Name
(3) Gender
(4) Yes or No
The issue is that some of the names are repeated so there is no way to group them together if one of the other columns like Distance is different. Take this small example, I would like to sort by Distance and name. Initially I have this:
Specialist Tool - (Active).xlsm | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | NAME | NEW | DISTANCE | ||
2 | Ron Smith | Yes | 2 | ||
3 | Jack Frost | No | 10 | ||
4 | Ron Smith | Yes | 20 | ||
Sheet2 |
Finally I would like this:
Specialist Tool - (Active).xlsm | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | NAME | NEW | DISTANCE | ||
2 | Ron Smith | Yes | 2 | ||
3 | Ron Smith | Yes | 20 | ||
4 | Jack Frost | No | 10 | ||
Sheet2 |
But there is no way to do this with sort because if you sort by distance, you could not group all the Ron Smith's together.
Any ideas? Please note the data size I am using is much larger (like 150+ rows)