theraindew
New Member
- Joined
- Dec 7, 2018
- Messages
- 9
- Office Version
- 365
- 2016
- Platform
- Windows
Hi,
I'm looking to sort columns in a specific way in the attached image.
Columns A & B - original data.
Columns D & E - sorted data.
Primary sort should be column B (Total), but duplicate fruit names should be clubbed together, regardless of the value of the duplicate fruit name.
Can this be done using a formula/helper column or even vba? Appreciate any help on this.
I'm looking to sort columns in a specific way in the attached image.
Columns A & B - original data.
Columns D & E - sorted data.
Primary sort should be column B (Total), but duplicate fruit names should be clubbed together, regardless of the value of the duplicate fruit name.
Can this be done using a formula/helper column or even vba? Appreciate any help on this.