Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
How to find a result in an array in the same row as a minimum resu
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Max, post: 3289824"] Use Index/match - set for an exact match The Index part of it is the col result that you want returned You could try something like this, array-entered* (untested) =INDEX($A$7:$A$2001,MATCH(MIN(IF(TEXT($A$7:$A$2001,"mmm,d")=X127,$D$7:$D$2001)),IF(TEXT($A$7:$A$2001,"mmm,d")=X127,$D$7:$D$2001),0)) *press CTRL+SHIFT+ENTER to confirm the formula Success? wave it, hit YES below [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
How to find a result in an array in the same row as a minimum resu
Top
