Assalamualaikum Wr. Wb.Para Master
Terimakasih Banyak Pencerahannya
Wassalamualaikum Wr. Wb.
Pada Selasa, 23 Mei 2017 9:31, "nangagus nanga...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
Asalamualaikum warahmatullah, Mas Kid saya tahu bedanya. Bedanya itu
hanya di huruf s-nya. COUNTIF dan COUNTIFS Waktu pelajaran di SMP dahulu huruf
S menyatakan jamak atau banyak kalau tanpa S berarti hanya satu. Sedangkan
untuk menjelaskan perbedaan formulanya secara detail ..... barangkali sama
ya...... saya kurang paham
=IF(COUNTIFS($C$5:$C$14;C5;$E$5:$E$14;E5)>1;"Double";"Tidak")
=IF(COUNTIFS($C$5:$C$14;C5;$F$5:$F$14;F5)>1;"Double";"Tidak")
salam
On 5/23/17 7:44 AM, 'Mr. Kid' mr.nm...@gmail.com [belajar-excel] wrote:
Wa'alaikumussalam wr wb
Coba pakai countifs. Apa sih beda countif dengan countifs? Tahukah? Adalah
yang tahu?
Wassalamu'alsikum wr wb Kid
Sent from my smart enough phone
On May 23, 2017, at 07:06, HAIRUL ALAM ha_m...@yahoo.co.id [belajar-excel]
<belajar-excel@yahoogroups.com> wrote:
Assalamualaikum Wr. Wb. Para Master
Bagaimana cara menentukan data double Pada Cell "C" Range "C5 - C14" dengan
hasil seperti Cell "I" yang saya highlight warna biru dan hijau yang dibedakan
berdasarkan criteria antara Cell "E" atau "F" (salah satunya) - Contoh terlampir
Terimakasih banyak pencerahannya
Wassalamualaikum Wr. Wb.
<MENENTUKAN DATA DOUBLE.xlsx>
#yiv2296189574 #yiv2296189574 -- #yiv2296189574ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2296189574
#yiv2296189574ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2296189574
#yiv2296189574ygrp-mkp #yiv2296189574hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2296189574 #yiv2296189574ygrp-mkp #yiv2296189574ads
{margin-bottom:10px;}#yiv2296189574 #yiv2296189574ygrp-mkp .yiv2296189574ad
{padding:0 0;}#yiv2296189574 #yiv2296189574ygrp-mkp .yiv2296189574ad p
{margin:0;}#yiv2296189574 #yiv2296189574ygrp-mkp .yiv2296189574ad a
{color:#0000ff;text-decoration:none;}#yiv2296189574 #yiv2296189574ygrp-sponsor
#yiv2296189574ygrp-lc {font-family:Arial;}#yiv2296189574
#yiv2296189574ygrp-sponsor #yiv2296189574ygrp-lc #yiv2296189574hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2296189574
#yiv2296189574ygrp-sponsor #yiv2296189574ygrp-lc .yiv2296189574ad
{margin-bottom:10px;padding:0 0;}#yiv2296189574 #yiv2296189574actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2296189574
#yiv2296189574activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2296189574
#yiv2296189574activity span {font-weight:700;}#yiv2296189574
#yiv2296189574activity span:first-child
{text-transform:uppercase;}#yiv2296189574 #yiv2296189574activity span a
{color:#5085b6;text-decoration:none;}#yiv2296189574 #yiv2296189574activity span
span {color:#ff7900;}#yiv2296189574 #yiv2296189574activity span
.yiv2296189574underline {text-decoration:underline;}#yiv2296189574
.yiv2296189574attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2296189574 .yiv2296189574attach div a
{text-decoration:none;}#yiv2296189574 .yiv2296189574attach img
{border:none;padding-right:5px;}#yiv2296189574 .yiv2296189574attach label
{display:block;margin-bottom:5px;}#yiv2296189574 .yiv2296189574attach label a
{text-decoration:none;}#yiv2296189574 blockquote {margin:0 0 0
4px;}#yiv2296189574 .yiv2296189574bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2296189574
.yiv2296189574bold a {text-decoration:none;}#yiv2296189574 dd.yiv2296189574last
p a {font-family:Verdana;font-weight:700;}#yiv2296189574 dd.yiv2296189574last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2296189574
dd.yiv2296189574last p span.yiv2296189574yshortcuts
{margin-right:0;}#yiv2296189574 div.yiv2296189574attach-table div div a
{text-decoration:none;}#yiv2296189574 div.yiv2296189574attach-table
{width:400px;}#yiv2296189574 div.yiv2296189574file-title a, #yiv2296189574
div.yiv2296189574file-title a:active, #yiv2296189574
div.yiv2296189574file-title a:hover, #yiv2296189574 div.yiv2296189574file-title
a:visited {text-decoration:none;}#yiv2296189574 div.yiv2296189574photo-title a,
#yiv2296189574 div.yiv2296189574photo-title a:active, #yiv2296189574
div.yiv2296189574photo-title a:hover, #yiv2296189574
div.yiv2296189574photo-title a:visited {text-decoration:none;}#yiv2296189574
div#yiv2296189574ygrp-mlmsg #yiv2296189574ygrp-msg p a
span.yiv2296189574yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2296189574
.yiv2296189574green {color:#628c2a;}#yiv2296189574 .yiv2296189574MsoNormal
{margin:0 0 0 0;}#yiv2296189574 o {font-size:0;}#yiv2296189574
#yiv2296189574photos div {float:left;width:72px;}#yiv2296189574
#yiv2296189574photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2296189574
#yiv2296189574photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2296189574
#yiv2296189574reco-category {font-size:77%;}#yiv2296189574
#yiv2296189574reco-desc {font-size:77%;}#yiv2296189574 .yiv2296189574replbq
{margin:4px;}#yiv2296189574 #yiv2296189574ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2296189574 #yiv2296189574ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2296189574
#yiv2296189574ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2296189574
#yiv2296189574ygrp-mlmsg select, #yiv2296189574 input, #yiv2296189574 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2296189574
#yiv2296189574ygrp-mlmsg pre, #yiv2296189574 code {font:115%
monospace;}#yiv2296189574 #yiv2296189574ygrp-mlmsg *
{line-height:1.22em;}#yiv2296189574 #yiv2296189574ygrp-mlmsg #yiv2296189574logo
{padding-bottom:10px;}#yiv2296189574 #yiv2296189574ygrp-msg p a
{font-family:Verdana;}#yiv2296189574 #yiv2296189574ygrp-msg
p#yiv2296189574attach-count span {color:#1E66AE;font-weight:700;}#yiv2296189574
#yiv2296189574ygrp-reco #yiv2296189574reco-head
{color:#ff7900;font-weight:700;}#yiv2296189574 #yiv2296189574ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2296189574 #yiv2296189574ygrp-sponsor
#yiv2296189574ov li a {font-size:130%;text-decoration:none;}#yiv2296189574
#yiv2296189574ygrp-sponsor #yiv2296189574ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2296189574
#yiv2296189574ygrp-sponsor #yiv2296189574ov ul {margin:0;padding:0 0 0
8px;}#yiv2296189574 #yiv2296189574ygrp-text
{font-family:Georgia;}#yiv2296189574 #yiv2296189574ygrp-text p {margin:0 0 1em
0;}#yiv2296189574 #yiv2296189574ygrp-text tt {font-size:120%;}#yiv2296189574
#yiv2296189574ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2296189574
