Hi,
I would like to calculate some result by sorting function, what should I use the excel formula?
1. in (I2), make a result of how many days between "tom" last winning(rank 1) date till the date I fill in (F2).
2. in (J2), by filling track(H2)-(please note that I want to group the track i.e A2=A & A2 & A3), and sort how many times did "tom" play rank 1 or 2 or 3 before the fill date(F2).
3.png
Bookmarks