LinkBack URL
About LinkBacks
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.
Yes.Originally Posted by tomassitoo
You've missed 2 semicolons I guess.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
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)
Posting Permissions
Register To Reply
Bookmarks