LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 46
Default Show Top 3 Values

Hello,

I have a worksheet with several records(rows) and each record contains
several columns (5) with values. What I would like to do is to display the
top 3 values from that record. How would I set that up?

Sample Data:
For Row 1
ColA: 100
ColB: 150
ColC: 250
ColD:115
ColE:250

Top 3 Values would be from the list above would be: 250, 250, and 150. I
don't want to manually do this for 1500 records. Is there a way to write a
function for this?

Thanks in Advance.
 
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
Show Values in KG and LBs sahafi Charts and Charting in Excel 4 April 11th 07 04:52 AM
3 values, show which ones are same AmyTaylor Excel Worksheet Functions 4 December 6th 05 07:29 PM
Show zero values johnny Excel Discussion (Misc queries) 4 December 5th 05 03:12 PM
How can I get the zero values at the end of a chart not to show? wabmreo Charts and Charting in Excel 3 December 2nd 05 11:01 PM
Show values from other sheet TONY Excel Worksheet Functions 0 August 31st 05 03:03 PM


All times are GMT +1. The time now is 03:29 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"