Sort within outline group

[fifer]

Hi all,

How do I sort within an outline group?

I have a set of data grouped by country, and would like to sort both levels of data by the same column. Using a regular sort function just sorts the country level, and doesn't sort items within. How would I do this without using VBA? Seems like should be possible......

I have a large automated file, simplified below. Number of items within each country can change with each daily feed.

[TABLE="width: 400"]
<tbody>[TR]
[TD]Country[/TD]
[TD]Item[/TD]
[TD]Score[/TD]
[/TR]
[TR]
[TD]Japan[/TD]
[TD][/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]abc[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]def[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ghi[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]USA[/TD]
[TD][/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]jkl[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]mno[/TD]
[TD]-3[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]pqr[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

The easiest way I can think of is to put the country name in every row where it applies. Then you can create a custom sort with country as first level and item as second level.

 

[fifer]

Thanks - I had considered that, but as number of items within each country will change regularly would still require manual intervention(unless VBA is used).