Posts by azumi

    Any Suggestion about this stuff :


    [TABLE="class: grid, width: 500, align: left"]

    [tr]


    [TD="align: center"]Score
    [/TD]
    [TD="align: center"]Rank
    [/TD]
    [TD="align: center"]Score
    [/TD]
    [TD="align: center"]Rank
    [/TD]

    [/tr]


    [tr]


    [TD="align: center"]25
    [/TD]
    [TD="align: center"]9
    [/TD]
    [TD="align: center"]26
    [/TD]
    [TD="align: center"]8
    [/TD]

    [/tr]


    [tr]


    [TD="align: center"]32
    [/TD]
    [TD="align: center"]6
    [/TD]
    [TD="align: center"]78
    [/TD]
    [TD="align: center"]3
    [/TD]

    [/tr]


    [tr]


    [TD="align: center"]78
    [/TD]
    [TD="align: center"]3
    [/TD]
    [TD="align: center"]200
    [/TD]
    [TD="align: center"]1
    [/TD]

    [/tr]


    [tr]


    [TD="align: center"]54
    [/TD]
    [TD="align: center"]5
    [/TD]
    [TD="align: center"]150
    [/TD]
    [TD="align: center"]2
    [/TD]

    [/tr]


    [tr]


    [TD="align: center"]15
    [/TD]
    [TD="align: center"]10
    [/TD]
    [TD="align: center"]32
    [/TD]
    [TD="align: center"]6
    [/TD]

    [/tr]


    [/TABLE]











    I try to solve this problem with this formula :
    B2
    =RANK(A2;($A$2:$A$6;$C$2:$C$6);0)


    But it does'nt break the ties


    Any add up for this formula?