Ranking on Multiple Ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Anyone able to help?
 
One way is to name the aresa by selecting them and

Insert|name|define.

The refer to them :-

=RANK(A1,newrange,0)

Mike
 
Back
Top