mitchosu

Junior Member

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Ranking data	LiAD	Excel Worksheet Functions	3	January 7th 09 04:45 PM
data ranking	yves	Excel Worksheet Functions	2	February 1st 07 08:13 PM
Ranking Data	Marcus	Excel Discussion (Misc queries)	7	April 28th 06 02:07 AM
Ranking Data	NickyV	Excel Discussion (Misc queries)	2	April 20th 06 09:19 PM
Ranking Data	LJDL	Excel Worksheet Functions	2	September 19th 05 05:27 PM

All times are GMT +1. The time now is 01:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us