hat
Chwazi yon selil vid kote ou pral mete rezilta nan klasman, antre nan fòmil sa a =1+SUMPRODUCT(($A$2:$A$12=A2)*($B$2:$B$12&gt;B2)), laprès Antre nan kle, epi trennen manyen sou selil yo pou aplike fòmil sa a.
eng
Select a blank cell which you will place the ranking result, enter this formula =1+SUMPRODUCT(($A$2:$A$12=A2)*($B$2:$B$12&gt;B2)), press Enter key, and drag fill handle over the cells to apply this formula.