Ranking on Multiple Ranges
 

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 P8:P1500
and I want to be able to rank say B8 out of ALL the data in all columns...

Anyone able to help?

Ranking on Multiple Ranges
 

One way is to name the aresa by selecting them and

Insert|name|define.

The refer to them :-

=RANK(A1,newrange,0)

Mike

"WBTKbeezy" wrote:

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 P8:P1500
and I want to be able to rank say B8 out of ALL the data in all columns...

Anyone able to help?

Ranking on Multiple Ranges
 

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

"Mike H" wrote:

One way is to name the aresa by selecting them and

Insert|name|define.

The refer to them :-

=RANK(A1,newrange,0)

Mike

"WBTKbeezy" wrote:

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 P8:P1500
and I want to be able to rank say B8 out of ALL the data in all columns...

Anyone able to help?