Terima kasih pak lazuardi, aq baru tau jika ada penulisan kriteria "*"&$B1&"*"
untuk mencari teks tertentu.
SalamHaris
On Friday, December 18, 2015 9:01 AM, "Lazuardi Biru
[email protected] [belajar-excel]" <[email protected]>
wrote:
to p. hariscoba pakai countif.
jika data ada di A1:A4 dan kata kunci Di B1di C1 tulis
=COUNTIF($A$1:$A$4;"*"&B1&"*")
salam
lb
Pada Jumat, 18 Desember 2015 8:32, "ris ha [email protected]
[belajar-excel]" <[email protected]> menulis:
Assalamu'alaikum.
Semoga suhu dan master excel dalam keadaan sehat.
Mohon solusinya, bagaimana caranya menghitung data dg kriteria yang
terselubung. MisalDataBapak berjalan ke kantor
Anak berjalan ke sekolahIbu berkendaraan ke pasarIbu berkendaraan ke kantor
HasilBerjalan = 2Ke = 4Ibu = 2Pasar = 1
Terima kasih atas solusi yg selalu power full selama ini. Semoga dibalas dengan
kemudahan rizki dan segala urusan. Amin
SalamHaris
#yiv3131081522 #yiv3131081522 -- #yiv3131081522ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3131081522
#yiv3131081522ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3131081522
#yiv3131081522ygrp-mkp #yiv3131081522hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3131081522 #yiv3131081522ygrp-mkp #yiv3131081522ads
{margin-bottom:10px;}#yiv3131081522 #yiv3131081522ygrp-mkp .yiv3131081522ad
{padding:0 0;}#yiv3131081522 #yiv3131081522ygrp-mkp .yiv3131081522ad p
{margin:0;}#yiv3131081522 #yiv3131081522ygrp-mkp .yiv3131081522ad a
{color:#0000ff;text-decoration:none;}#yiv3131081522 #yiv3131081522ygrp-sponsor
#yiv3131081522ygrp-lc {font-family:Arial;}#yiv3131081522
#yiv3131081522ygrp-sponsor #yiv3131081522ygrp-lc #yiv3131081522hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3131081522
#yiv3131081522ygrp-sponsor #yiv3131081522ygrp-lc .yiv3131081522ad
{margin-bottom:10px;padding:0 0;}#yiv3131081522 #yiv3131081522actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3131081522
#yiv3131081522activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3131081522
#yiv3131081522activity span {font-weight:700;}#yiv3131081522
#yiv3131081522activity span:first-child
{text-transform:uppercase;}#yiv3131081522 #yiv3131081522activity span a
{color:#5085b6;text-decoration:none;}#yiv3131081522 #yiv3131081522activity span
span {color:#ff7900;}#yiv3131081522 #yiv3131081522activity span
.yiv3131081522underline {text-decoration:underline;}#yiv3131081522
.yiv3131081522attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3131081522 .yiv3131081522attach div a
{text-decoration:none;}#yiv3131081522 .yiv3131081522attach img
{border:none;padding-right:5px;}#yiv3131081522 .yiv3131081522attach label
{display:block;margin-bottom:5px;}#yiv3131081522 .yiv3131081522attach label a
{text-decoration:none;}#yiv3131081522 blockquote {margin:0 0 0
4px;}#yiv3131081522 .yiv3131081522bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3131081522
.yiv3131081522bold a {text-decoration:none;}#yiv3131081522 dd.yiv3131081522last
p a {font-family:Verdana;font-weight:700;}#yiv3131081522 dd.yiv3131081522last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3131081522
dd.yiv3131081522last p span.yiv3131081522yshortcuts
{margin-right:0;}#yiv3131081522 div.yiv3131081522attach-table div div a
{text-decoration:none;}#yiv3131081522 div.yiv3131081522attach-table
{width:400px;}#yiv3131081522 div.yiv3131081522file-title a, #yiv3131081522
div.yiv3131081522file-title a:active, #yiv3131081522
div.yiv3131081522file-title a:hover, #yiv3131081522 div.yiv3131081522file-title
a:visited {text-decoration:none;}#yiv3131081522 div.yiv3131081522photo-title a,
#yiv3131081522 div.yiv3131081522photo-title a:active, #yiv3131081522
div.yiv3131081522photo-title a:hover, #yiv3131081522
div.yiv3131081522photo-title a:visited {text-decoration:none;}#yiv3131081522
div#yiv3131081522ygrp-mlmsg #yiv3131081522ygrp-msg p a
span.yiv3131081522yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3131081522
.yiv3131081522green {color:#628c2a;}#yiv3131081522 .yiv3131081522MsoNormal
{margin:0 0 0 0;}#yiv3131081522 o {font-size:0;}#yiv3131081522
#yiv3131081522photos div {float:left;width:72px;}#yiv3131081522
#yiv3131081522photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3131081522
#yiv3131081522photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3131081522
#yiv3131081522reco-category {font-size:77%;}#yiv3131081522
#yiv3131081522reco-desc {font-size:77%;}#yiv3131081522 .yiv3131081522replbq
{margin:4px;}#yiv3131081522 #yiv3131081522ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3131081522 #yiv3131081522ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3131081522
#yiv3131081522ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3131081522
#yiv3131081522ygrp-mlmsg select, #yiv3131081522 input, #yiv3131081522 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3131081522
#yiv3131081522ygrp-mlmsg pre, #yiv3131081522 code {font:115%
monospace;}#yiv3131081522 #yiv3131081522ygrp-mlmsg *
{line-height:1.22em;}#yiv3131081522 #yiv3131081522ygrp-mlmsg #yiv3131081522logo
{padding-bottom:10px;}#yiv3131081522 #yiv3131081522ygrp-msg p a
{font-family:Verdana;}#yiv3131081522 #yiv3131081522ygrp-msg
p#yiv3131081522attach-count span {color:#1E66AE;font-weight:700;}#yiv3131081522
#yiv3131081522ygrp-reco #yiv3131081522reco-head
{color:#ff7900;font-weight:700;}#yiv3131081522 #yiv3131081522ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3131081522 #yiv3131081522ygrp-sponsor
#yiv3131081522ov li a {font-size:130%;text-decoration:none;}#yiv3131081522
#yiv3131081522ygrp-sponsor #yiv3131081522ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3131081522
#yiv3131081522ygrp-sponsor #yiv3131081522ov ul {margin:0;padding:0 0 0
8px;}#yiv3131081522 #yiv3131081522ygrp-text
{font-family:Georgia;}#yiv3131081522 #yiv3131081522ygrp-text p {margin:0 0 1em
0;}#yiv3131081522 #yiv3131081522ygrp-text tt {font-size:120%;}#yiv3131081522
#yiv3131081522ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3131081522
