Hai Sinurat,Sdh coba pakai Countif?Criterianya "*50". Salam,HK Sent from Yahoo Mail on Android On Mon, Feb 13, 2017 at 3:16, Imam Sinurat [email protected] [belajar-excel]<[email protected]> wrote:
| Yth. Para Admin dan rekan2… mohon bantuan formula dan/atau sintax vbe-nya. | | | | | | | | | | | | | 307 | 964 | 340 | | | | | | | | 450 | 271 | 563 | | | | | | | | 768 | 163 | 458 | | | | | | | | 672 | 456 | 250 | | | | | | | | 651 | 950 | 364 | | | | | | | | | | | | | | | | | | Pertanyaan : | | | | | | | | | Dari range data tersebut, berapa banyakkah sel yang "dua digit terakhirnya" bernilai 50?? | | | | | | | | | | | | Terima kasih | | | | | | | | | Sinurat | | | | | | | | |
