Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Show Values in KG and LBs | Charts and Charting in Excel | |||
3 values, show which ones are same | Excel Worksheet Functions | |||
Show zero values | Excel Discussion (Misc queries) | |||
How can I get the zero values at the end of a chart not to show? | Charts and Charting in Excel | |||
Show values from other sheet | Excel Worksheet Functions |