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.

Country	Item	Score
Japan		9
	abc	1
	def	6
	ghi	2
USA		10
	jkl	8
	mno	-3
	pqr	5

<tbody>
</tbody>

 

[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).