BJ, thanks for the reply. I thin kmy wording was off a bit. What we
are trying to do is compare the US High Sales to the ROW High Sales,
and find the top 100 out of both columns and then compare the US Low
Sales with the ROW Low Sales and find the bottom most 100.

I am not familar with the Rank function. What is it and how does it
work?

Marcia