 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / August 2006Need some help
Is there any way to use a function like this: =OFFSET(MAX(A2:E2),1,2,1,1) the goal is to find the first 3 bigger values in a row and return them with the title of the column.  SignatureJohn21 From Excel help on Offset: OFFSET(reference,rows,cols,height,width) Reference is the reference from which you want to base the offset. Reference must refer to a cell or range of adjacent cells; otherwise, OFFSET returns the #VALUE! error value. ------------------- The first argument must be a cell reference, not a value: MAX(A2:E2) Biff > Is there any way to use a function like this: > =OFFSET(MAX(A2:E2),1,2,1,1) > > the goal is to find the first 3 bigger values in a row and return them > with the title of the column. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.