≡ Menu

Excel: Cara Kira Berapa Kekerapan X Di Row

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;

0 comments… add one

Leave a Comment