Trying to sort 6 columns in sets of two

[bteddy1]

Trying to sort 6 columns in sets of two.
I have a sheet with a range of data in groups by year.

I have 6 columns grouped by year (data to search for, countif to search range)
EXAMPLE;
YEAR: 2006 2007 2008
COLUMNS : A B C D E F
(DATA) (COUNT) (DATA) (COUNT) (DATA) (COUNT)

I need to sort each column group (A&B…) in descending order of “count”
I select each column range and sort. The first column sorts correctly but the others, when selected, will not sort correctly.

Thank you

[robleyd]

Can you provide a small sample spreadsheet, so we don’t have to a) guess what data you have and b) create a spreadsheet to test?

[LeroyG]

What I guess:

YEAR:	2006		2007		2008
COLUMNS:	A	B	C	D	E	F
	(DATA)	(COUNT)	(DATA)	(COUNT)	(DATA)	(COUNT)

You must select and sort A&B, then C&D, then E&F.