• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Another Sort Question

Kenshin

Member
Nice day ninjaz, bow to you asking for help, please see the file attach for clear explanation
 

Attachments

  • Sort Problemo.xlsx
    9.5 KB · Views: 4
Try,

1] Result Table put in E11:F16

2] F11, copied down :

=IFERROR(LARGE(INDEX($C$2:$I$6,MATCH($B$10,$B$2:$B$6,0),0),ROWS($1:1)),"")

3] E11, copied down :

=IF(F11="","",INDEX($C$1:$I$1,AGGREGATE(15,6,COLUMN($C$1:$I$1)-COLUMN($B$1)/(INDEX($C$2:$I$6,MATCH($B$10,$B$2:$B$6,0),0)=F11),COUNTIF(F$11:F11,F11))))

Regards
Bosco
 

Attachments

  • Sort Problemo(1).xlsx
    11.1 KB · Views: 7
Back
Top