Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 129
Default Ranking

With ref to the below table:

a b c d e

A 1 5 6 8 2
B 6 9 10 11 12
C 9 8 7 7 4
D 1 2 3 4 19
E 13 14 15 20 5
F 6 7 8 9 10

Which formula shd I use if I need to rank them according to col & row:

Largest: (E, d)
2nd : (D, e)
3rd : (E, c)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 Blade370 Excel Worksheet Functions 6 February 8th 07 10:53 AM
Ranking SBárbara Excel Discussion (Misc queries) 3 December 14th 06 06:39 PM
Ranking linzi00 Excel Discussion (Misc queries) 2 October 5th 06 05:42 PM
ranking Soz Excel Worksheet Functions 6 September 14th 05 05:55 PM
Ranking Tim Sullivan Excel Worksheet Functions 7 July 18th 05 07:00 PM


All times are GMT +1. The time now is 02:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"