Cara Kira Kekerapan X di Column Name
Formula: =COUNTIF($B$2:$B$200,P2)
Bil | Name | X |
1 | MUHAMMAD FIKRY BIN KAMARULZAMAN | 12 |
2 | MUHAMMAD NOR IKMAL BIN YASRI | 12 |
3 | NOR ATIKAH BINTI KAMARULZAMAN | 12 |
4 | SURIA BINTI MOHAMED SELOR | 11 |
Other articles you might like;