LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
John Terry
 
Posts: n/a
Default Find top 10 scores

My data is arranged as below with 40 columns
Com-a Com-b Com-c Com-d .....Com....... 40 columns
-1.542 -4.628 -6.607 -1.831
3.127 0.772 0.717 4.108
7.002 6.805 7.009 8.706
9.364 10.169 7.826 10.396
4.169 4.117 0.337 5.087
I need to select the top 10 scores in the last row and report this along
with the column heading for identification.

Thanks
 
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
How do I compare data in two worksheets to find matching cells? Gary Excel Discussion (Misc queries) 4 March 2nd 06 09:04 PM
Excel has a "Find Next" command but no "Find Previous" command. Michael Fitzpatrick Excel Discussion (Misc queries) 2 January 10th 05 11:45 PM
Find & Replace results to display specified chosen fields samuel Excel Discussion (Misc queries) 1 December 28th 04 08:43 AM
Find duplicates R. Choate Excel Discussion (Misc queries) 5 November 28th 04 10:14 PM
Need formule which would find cell (exmp b3) value on another worksheet! please help! StarGazer Excel Worksheet Functions 1 October 28th 04 08:39 AM


All times are GMT +1. The time now is 12:42 PM.

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"