 |
 | 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 / December 2005Excel Formula - Reg
I have a matrix with 1 row and 20 columns, the couple cells contain a numeric value and an associated text in the next column, like this there are 15 couple of sets. Now using Min(Value1,Value2..,) i can find the min of all the numeric values, but how to get the text coupled with the minimum value? Regards Murali lmurali@india.quantechglobal.com Assuming data is in row1, in the structure: number, text, number, text, ... and there are no ties in the min value Eg in A1 across are: 1, Text1, 2, Text2, 0.9, Text3, ... (corresponding text to the right of the number) Put in say, A3: =INDEX(1:1,MATCH(MIN(1:1),1:1,0)+1) A3 will return the text coupled with the min value For the sample data, A3 will return: Text3 If there are ties in the min value, A3 will return the text next to the first* min value *first from the left -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- > I have a matrix with 1 row and 20 columns, the couple cells contain a numeric > value and an associated text in the next column, like this there are 15 [quoted text clipped - 6 lines] > Murali > lmurali@india.quantechglobal.com |
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
|
©2009 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.