| 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? |
| 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 | |||
Threaded Mode
