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 |
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 |
Next post: Excel: Proper Nama Tanpa BIN BINTI + Chinese Name
Previous post: Cara Duplicate File Google Drive Secara Bulk