Posted to microsoft.public.excel.worksheet.functions

Blade370

external usenet poster

Posts: 21

ranking

I have a table which looks like this

PERCENTAGE PLAYED WON LOST DRAWN TOTAL SCORE
70.0% 5 3 1 1 10
50.0% 5 2 2 1 7
50.0% 5 2 2 1 7
50.0% 5 2 2 1 7
50.0% 5 2 2 1 7
50.0% 5 2 2 1 7
66.7% 3 2 1 0 6
75.0% 2 1 0 1 4
50.0% 2 1 1 0 3
12.5% 4 0 3 1 1
50.0% 1 0 0 1 1
25.0% 2 0 1 1 1

I want to rank by the percentage column but when it still seems to rank by
games won. Any ideas???

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 problem	austuni	Excel Worksheet Functions	1	October 19th 06 08:53 PM
Ranking a List which must be within GROUPS	Gary Jordan	Excel Discussion (Misc queries)	0	May 24th 06 02:06 PM
ranking with some blank spaces	LRR via OfficeKB.com	Excel Worksheet Functions	7	April 16th 06 03:04 PM
Numbers used for Ranking	Lowkey	Excel Worksheet Functions	4	May 27th 05 11:26 PM
Ranking Using Grand Total	nostalgie	Excel Discussion (Misc queries)	0	April 9th 05 03:27 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us