Ranking on Multiple Ranges

[Guest]

Is there a way I can rank data in multiple ranges? Right now I have 4 data
sets that are a few columns apart from each other... I want to be able to
rank each sales amount in each column out of the total sales $ from ALL
Columns.

Currently there is data in Columns B8:B1500, H8:H1500 L8:L1500 and P81500
and I want to be able to rank say B8 out of ALL the data in all columns...

Anyone able to help?

 

[Guest]

One way is to name the aresa by selecting them and

Insert|name|define.

The refer to them :-

=RANK(A1,newrange,0)

Mike

 

[Guest]

That is EXACTLY what I was looking for, I forgot you can name ranges like
that, thanks!