BakerBaker
New Member
- Joined
- Feb 12, 2018
- Messages
- 38
- Office Version
- 2019
- Platform
- Windows
Help greatly appreciated on this. Below is a simple representation of a larger data set. I wish to sort each block of rows by column with the numerical value in Col. B descending from Largest to Smallest.
<tbody>
</tbody>
Col. A | Col.B | To give result: | Col. A | Col.B |
Birds | 9 | Dogs | 14 | |
Dogs | 14 | Birds | 9 | |
Horses | 3 | Horses | 3 | |
Blank | ||||
Cows | 4 | Pigs | 16 | |
Sheep | 11 | Sheep | 11 | |
Pigs | 16 | Cows | 4 | |
Goats | 4 | Goats | 4 | |
Blank | ||||
Poultry | 3 | Horses | 34 | |
Cows | 22 | Cows | 22 | |
Horses | 34 | Domestic | 14 | |
Pigs | 4 | Others | 11 | |
Others | 11 | Pigs | 4 | |
Domestic | 14 | Poultry | 3 | |
Blank | ||||
etc. Thanks |
<tbody>
</tbody>