I was able to do the rank, but I don't how this will really help with my
goal.
I need to be able to capture a value (sales) from 2 different sheets
corresponding to the same value (affiliate ID)...

so lets say sheet 1 is like this

Affiliate number sales
2 $10
5 $5

sheet 2 is like
Affiliate number sales
2 $13
1 $12
5 $3

then the final result would be

Affiliate number sales 04 sales 05
1 - $12
2 $10 $13
5 $5 $3

Then I can get the percentage of change, and then rank by percentage of
rank.

Any ideas?

Thanks


--
skuba
------------------------------------------------------------------------
skuba's Profile: http://www.excelforum.com/member.php...fo&userid=6696
View this thread: http://www.excelforum.com/showthread...hreadid=503110