Pada kolom A ada himpunan karakter, yang akan dipilih dan dihitung karakter A,B,A1,A1B2,A2B1
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqOcXN6kpRQYXxbW-QR36ENUelknsthmJUHZnQg8qb5tKg6HLN6dXONEhfPVE_FH9-icXLqtPFwhlzkZTHiqz6JGptQpI7v-kxYeel7DW6QxvSrWiFQovG-59kRfnx-st53FpxBf1Lv2g_/s400/hitung+karakter+01b.jpg)
Untuk menghitung karakternya, maka buat fomula berikut:
Di sel B6 ketik formula:
=LEN(A6) - LEN(SUBSTITUTE(A6,"A",""))
Di sel C6 ketik formula:
=LEN(A6) - LEN(SUBSTITUTE(A6,"B",""))
Di sel D6 ketik formula:
=(LEN(A6) - LEN(SUBSTITUTE(A6,"A1","")))/2
Di sel E6 ketik formula:
=(LEN(A6) - LEN(SUBSTITUTE(A6,"A1B2","")))/4
Di sel F6 ketik formula:
=(LEN(A6) - LEN(SUBSTITUTE(A6,"A2B1","")))/4
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzYkbH9_cQ7AtLfRgM3jfy6Gp3XSMWowxoGoKVcQNzB9urkKgNZjYklY90L5Aijohzjguq1CjP2_G6FSLOlSNcqKYOZT5QcGGIGTr7AUdDP_JcRXd8_FE_0AkXi-ldHKgCipgStveliPz6/s400/hitung+karakter+02b.jpg)
No comments:
Post a Comment