Ranking on Multiple Ranges

W

WBTKbeezy

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?
 
M

Mike H

One way is to name the aresa by selecting them and

Insert|name|define.

The refer to them :-

=RANK(A1,newrange,0)

Mike
 
W

WBTKbeezy

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