I'm trying to write code to compare revenue data by state year ove
year. For purposes of my analysis, I need the states sorted i
descending order by revenue for the most recent year, then each prio
year needs to be sorted in the same order. So, if I receive data a
such:

2005

MA $1000
TN $950
IL $800
MN $300


2004

IL $5000
MN $300
TN $200
MA $50

I needed to sort the 2004 revenue data, so that the states are liste
in the same ordered as 2005, as seen below:

2004

MA $50
TN $200
IL $5000
MN $300

Does anyone know an efficient way to do this? I feel like their mus
be a way to store all this data in one array and then build a tabl
using the array.

Any help would be greatly appreciated.

Thanks,
Pete

--
PGalla0
-----------------------------------------------------------------------
PGalla06's Profile: http://www.excelforum.com/member.php...fo&userid=2426
View this thread: http://www.excelforum.com/showthread.php?threadid=46901