| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ranking from multiple columns | Excel Discussion (Misc queries) | |||
| Can I create Multiple passwords to edit multiple ranges? | Excel Discussion (Misc queries) | |||
| Ranking multiple columns by 1000th inch | Excel Worksheet Functions | |||
| How do i update multiple data ranges across multiple worksheets? | Excel Discussion (Misc queries) | |||
| Ranking within in ranges | Excel Worksheet Functions | |||
Hybrid Mode
