peterappiahkubi
New Member
- Joined
- Jun 12, 2021
- Messages
- 11
- Office Version
- 2013
- Platform
- Windows
Sort function was introduced in Excel 365Did you try the sort function?
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | S/N | NAME | TOTAL MARKS | POSITION | ||
2 | 1 | APPIAH DWAAH JESUS | 609 | 4TH | ||
3 | 2 | APPIAH OSEI KWAME | 510 | 9TH | ||
4 | 3 | ASAMOAH JOSIAH FRIMPONG | 586 | 7TH | ||
5 | 4 | COBBINAH PHILIP | 615 | 3RD | ||
6 | 5 | KANKAM KINGSLEY | 625 | 1ST | ||
7 | 6 | LEH KOJO RAYMOND | 577 | 8TH | ||
8 | 7 | OPPONG BLESSING | 507 | 10TH | ||
9 | 8 | OWUSU LUCKY | 618 | 2ND | ||
10 | 9 | PABLO NELSON | 600 | 6TH | ||
11 | 10 | YEBOAH KWAKU JONATHON | 609 | 4TH | ||
Sheet1 |
=LOOKUP(99^99,--(0&MID(D2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},D2&1234567890)),ROW(INDIRECT("1:"&LEN(D2)+1)))))
=INDEX($A$2:$A$11,MATCH(H2,$D$2:$D$11,0))
=IF(SMALL($E$2:$E$100,ROW()-1)=1,SMALL($E$2:$E$100,ROW()-1)&"st",IF(SMALL($E$2:$E$100,ROW()-1)=2,SMALL($E$2:$E$100,ROW()-1)&"nd",IF(SMALL($E$2:$E$100,ROW()-1)=3,SMALL($E$2:$E$100,ROW()-1)&"rd",IF(SMALL($E$2:$E$100,ROW()-1)>=4,SMALL($E$2:$E$100,ROW()-1)&"th",""))))
=VLOOKUP($G2,$A$2:$C$11,COLUMN(B$1),FALSE)
+Fluff 1.xlsm | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | S/N | NAME | TOTAL MARKS | POSITION | S/N | NAME | TOTAL MARKS | POSITION | ||||
2 | 1 | APPIAH DWAAH JESUS | 609 | 4TH | 625 | 5 | KANKAM KINGSLEY | 625 | 1ST | |||
3 | 2 | APPIAH OSEI KWAME | 510 | 9TH | 618 | 8 | OWUSU LUCKY | 618 | 2ND | |||
4 | 3 | ASAMOAH JOSIAH FRIMPONG | 586 | 7TH | 615 | 4 | COBBINAH PHILIP | 615 | 3RD | |||
5 | 4 | COBBINAH PHILIP | 615 | 3RD | 609 | 1 | APPIAH DWAAH JESUS | 609 | 4TH | |||
6 | 5 | KANKAM KINGSLEY | 625 | 1ST | 609 | 10 | YEBOAH KWAKU JONATHON | 609 | 4TH | |||
7 | 6 | LEH KOJO RAYMOND | 577 | 8TH | 600 | 9 | PABLO NELSON | 600 | 6TH | |||
8 | 7 | OPPONG BLESSING | 507 | 10TH | 586 | 3 | ASAMOAH JOSIAH FRIMPONG | 586 | 7TH | |||
9 | 8 | OWUSU LUCKY | 618 | 2ND | 577 | 6 | LEH KOJO RAYMOND | 577 | 8TH | |||
10 | 9 | PABLO NELSON | 600 | 6TH | 510 | 2 | APPIAH OSEI KWAME | 510 | 9TH | |||
11 | 10 | YEBOAH KWAKU JONATHON | 609 | 4TH | 507 | 7 | OPPONG BLESSING | 507 | 10TH | |||
Lists |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F2:F11 | F2 | =LARGE($C$2:$C$11,ROWS(F$2:F2)) |
G2:J11 | G2 | =INDEX(A$2:A$11,AGGREGATE(15,6,(ROW($C$2:$C$11)-ROW($C$2)+1)/($C$2:$C$11=$F2),COUNTIFS($F$2:$F2,$F2))) |
How about
i got it. thanks soo much
Aggregate_a.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | S/N | NAME | TOTAL MARKS | POSITION | ||
2 | 5 | KANKAM KINGSLEY | 625 | 1ST | ||
3 | 8 | OWUSU LUCKY | 618 | 2ND | ||
4 | 4 | COBBINAH PHILIP | 615 | 3RD | ||
5 | 1 | APPIAH DWAAH JESUS | 609 | 4TH | ||
6 | 10 | YEBOAH KWAKU JONATHON | 609 | 4TH | ||
7 | 9 | PABLO NELSON | 600 | 6TH | ||
8 | 3 | ASAMOAH JOSIAH FRIMPONG | 586 | 7TH | ||
9 | 6 | LEH KOJO RAYMOND | 577 | 8TH | ||
10 | 2 | APPIAH OSEI KWAME | 510 | 9TH | ||
11 | 7 | OPPONG BLESSING | 507 | 10TH | ||
3c |