Hello guys, could anyone, please, help with following task? I need to find a formula for sorting of results placed in H2:P10 to C2:D11. For example result J7 (2,L1,B) would be automatically positioned in C8? Thank you very much for the help!
Hello guys, could anyone, please, help with following task? I need to find a formula for sorting of results placed in H2:P10 to C2:D11. For example result J7 (2,L1,B) would be automatically positioned in C8? Thank you very much for the help!
Please try at C2:D11
=LOOKUP(1,1/($A2=$F$2:$F$9)/(C$1=$G$2:$G$9),INDEX($H$2:$P$9,,MATCH($B2,$H$1:$P$1,)))
I translated it to Czech version: =VYHLEDAT(1;1/($A2=$F$2:$F$9)/(C$1=$G$2:$G$9);INDEX($H$2:$P$9;POZVYHLEDAT($B2;$H$1:$P$1))) and it resulted in "#REF!". Is there any mistake in translated formula?
I don't know Czech, Please check from attached.
Yeah, it works now! Thank you very much! Could you maybe help me with one little modification? (I found I'm missing some rows) According to your formula, now, H2 is not matching C2, J2 is not matching C4. Do you have any suggestion? Thank you very much.
This only work with Excel 2010 or above
=INDEX($H:$P,AGGREGATE(15,6,ROW($F$2:$F$9)/($F$2:$F$9=$A2)/($G$2:$G$9=C$1),COUNTIFS($A$2:$A2,$A2,$B$2:$B2,$B2)),MATCH($B2,$H$1:$P$1,))
Thanks a lot. Any recommendation for Excel 2007?
C2
=INDEX($H:$P,SMALL(IF(($F$2:$F$9=$A2)*($G$2:$G$9=C$1),ROW($F$2:$F$9)),COUNTIFS($A$2:$A2,$A2,$B$2:$B2,$B2)),MATCH($B2,$H$1:$P$1,))
Press Ctrl+Shift+Enter
Man, you're genius, you saved my life! Thank you very much!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks