Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ranking data by a numeric value
I want to rank stocks buy a score I have assigned them. I would like to have a cumulative summery page that that ranks the highest to lowest scores. Some of the stocks will be scored once and some many times in different data sets.
score Ticker 100 BKW 99 IX 98 VG 97 OMX 96 SMFG 95 ATLC 94 ESI 93 MIL 92 ALU 91 PKX 90 AIG I cant up load a spreadsheet for some reason but one data set looks like this |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ranking data by a numeric value
On Mon, 10 Dec 2012 13:40:24 +0000, mitchosu wrote:
I want to rank stocks buy a score I have assigned them. I would like to have a cumulative summery page that that ranks the highest to lowest scores. Some of the stocks will be scored once and some many times in different data sets. score Ticker 100 BKW 99 IX 98 VG 97 OMX 96 SMFG 95 ATLC 94 ESI 93 MIL 92 ALU 91 PKX 90 AIG I cant up load a spreadsheet for some reason but one data set looks like this What is the difference between what you represent, and just sorting the results by Score (descending)? If you need to Rank the scores with numbers from 1-10 (as opposed to just looking at the row number or relative position in the table, you could just use the RANK function with ref = the Score column |
#3
|
|||
|
|||
Quote:
Feel free to email the file to me on pubnut @ gmail . com (with no spaces) and I'll take a look at it for you. Spencer. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ranking data | Excel Worksheet Functions | |||
data ranking | Excel Worksheet Functions | |||
Ranking Data | Excel Discussion (Misc queries) | |||
Ranking Data | Excel Discussion (Misc queries) | |||
Ranking Data | Excel Worksheet Functions |