Pak Budhi Yth,
Jika huruf a tersebut pasti hanya ada 1 disetiap cell data, seperti suatu
sandi item tertentu tertentu di sebuah set kode yang berisi berbagai macam
kriteria penyusun suatu produk misalnya, bisa gunakan CountIF.
=CountIF( b2:b4 , *a* )
Wassalam,
Kid.
2012/5/11 Budhi Cahyanto
Terima kasih Mr. Kid, it works.
Problem solved.
Please consider the environment before printing this email.
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
On Behalf Of Kid Mr.
Sent: 12 Mei 2012 05:49
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel
Terima kasih pak Ghozi, formulanya mantap.
Bisa digunakan.
Salam, Budhi
Please consider the environment before printing this email.
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On
Behalf Of ghozi alkatiri
Sent: 11 Mei 2012 21:50
To:
3 matches
Mail list logo