Hello,
I am looking for the minimum 10 values for cells j3:j12 from column D. The criteria is the values in column C must match those in cells f3:f12. Here is my formula:
=INDEX(D1:D292,MATCH(MIN(SUMPRODUCT(F3:F14=C1:C292),D1:D292),C1:C215,0),1)
I've had a lot of issues figuring this out so any help is appreciated!
Thanks,
Laura
Try this..
In J3..
Formula:
Please Login or Register to view this content.
Drag downward for more results..
Confirm the formula using Ctrl + Shift + Enter, Not Just Enter..
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Thanks! Now do you know how I would return the corresponding value in column A. I tried this but then it ignores the criteria:
=INDEX(A1:A292,MATCH(SMALL(IF(COUNTIF($F$3:$F$14,$C$1:$C$215)=1,$D$1:$D$215,"-"),ROW($A1)),D1:D292,0),1)
Thanks!
Hello Laura,
Try this in J3 with CTRL+SHIFT+ENTER,
=INDEX(F$3:F$14,MATCH(1,FREQUENCY(0,IFERROR(1/(SUMIF(C:C,F$3:F$14,D:D)*ISNA(MATCH(F$3:F$14,J$2:J2,0))),1)),0))
Then copy down.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Laura, disregard my previous post. I missed your 'minimum 10 values'
Ok no problem. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks