Terimakasih Pak Iqbal. Rumus itu digunakan untuk membuat nomor urut dari record yg sama, kalau record udah beda, maka nomor urut mulai dari 1. Btw, tadi udah nyoba pakai rumus =countif ($a$2:[@nim];[@nim]) Kayaknya udah berhasil ..
Dikirim dari Yahoo Mail di Android Pada Min, 18 Agt 2019 pada 15:38, iq_bal7...@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> menulis: Hi Ari, Pada rumus yang sampean buat , tiap baris ada perubahan jumlah yang di hitung Kalau tujuannya menghitung jumlah kata yang sama dalam 1 kolom, maka harusnya rumus nya tetap Dan karena table yang di buat sudah dalam bentuk table design dan bukan bentuk range, maka gunakan saja rumus berikut “=COUNTIF([nim],[@nim])” Sehingga tiap ada penambahan record di bawahnya, rumus akan otomatis mengikuti. Thanks Best Regards Muhammad Iqbal +62890909010/0811101854 From: belajar-excel@yahoogroups.com <belajar-excel@yahoogroups.com> Sent: Sunday, August 18, 2019 6:50 AM To: belajar-excel@yahoogroups.com Subject: [belajar-excel] Range Rumus Countif berubah pada exceltable Assalaamualaikum Wr wb Mohon pencerahannya. Saya membuat Excel table, salah satu kolomnya diberi rumus. Masalahnya, setiap ada penambahan data baru, rumus kolom tersebut jadi berubah (terjadi pada beberapa Cell). Mengapa begitu, mohon solusinya .. Terimakasih Ari Wassalaamualaikum wr wb Dikirim dari Yahoo Mail di Android <https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_And roidEmailSig__AndroidUsers_wl=ym_sub1=Internal_sub2=Global_YGrowth& af_sub3=EmailSignature> #yiv5405773197 #yiv5405773197 -- #yiv5405773197ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5405773197 #yiv5405773197ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5405773197 #yiv5405773197ygrp-mkp #yiv5405773197hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5405773197 #yiv5405773197ygrp-mkp #yiv5405773197ads {margin-bottom:10px;}#yiv5405773197 #yiv5405773197ygrp-mkp .yiv5405773197ad {padding:0 0;}#yiv5405773197 #yiv5405773197ygrp-mkp .yiv5405773197ad p {margin:0;}#yiv5405773197 #yiv5405773197ygrp-mkp .yiv5405773197ad a {color:#0000ff;text-decoration:none;}#yiv5405773197 #yiv5405773197ygrp-sponsor #yiv5405773197ygrp-lc {font-family:Arial;}#yiv5405773197 #yiv5405773197ygrp-sponsor #yiv5405773197ygrp-lc #yiv5405773197hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5405773197 #yiv5405773197ygrp-sponsor #yiv5405773197ygrp-lc .yiv5405773197ad {margin-bottom:10px;padding:0 0;}#yiv5405773197 #yiv5405773197actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5405773197 #yiv5405773197activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5405773197 #yiv5405773197activity span {font-weight:700;}#yiv5405773197 #yiv5405773197activity span:first-child {text-transform:uppercase;}#yiv5405773197 #yiv5405773197activity span a {color:#5085b6;text-decoration:none;}#yiv5405773197 #yiv5405773197activity span span {color:#ff7900;}#yiv5405773197 #yiv5405773197activity span .yiv5405773197underline {text-decoration:underline;}#yiv5405773197 .yiv5405773197attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5405773197 .yiv5405773197attach div a {text-decoration:none;}#yiv5405773197 .yiv5405773197attach img {border:none;padding-right:5px;}#yiv5405773197 .yiv5405773197attach label {display:block;margin-bottom:5px;}#yiv5405773197 .yiv5405773197attach label a {text-decoration:none;}#yiv5405773197 blockquote {margin:0 0 0 4px;}#yiv5405773197 .yiv5405773197bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5405773197 .yiv5405773197bold a {text-decoration:none;}#yiv5405773197 dd.yiv5405773197last p a {font-family:Verdana;font-weight:700;}#yiv5405773197 dd.yiv5405773197last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5405773197 dd.yiv5405773197last p span.yiv5405773197yshortcuts {margin-right:0;}#yiv5405773197 div.yiv5405773197attach-table div div a {text-decoration:none;}#yiv5405773197 div.yiv5405773197attach-table {width:400px;}#yiv5405773197 div.yiv5405773197file-title a, #yiv5405773197 div.yiv5405773197file-title a:active, #yiv5405773197 div.yiv5405773197file-title a:hover, #yiv5405773197 div.yiv5405773197file-title a:visited {text-decoration:none;}#yiv5405773197 div.yiv5405773197photo-title a, #yiv5405773197 div.yiv5405773197photo-title a:active, #yiv5405773197 div.yiv5405773197photo-title a:hover, #yiv5405773197 div.yiv5405773197photo-title a:visited {text-decoration:none;}#yiv5405773197 div#yiv5405773197ygrp-mlmsg #yiv5405773197ygrp-msg p a span.yiv5405773197yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5405773197 .yiv5405773197green {color:#628c2a;}#yiv5405773197 .yiv5405773197MsoNormal {margin:0 0 0 0;}#yiv5405773197 o {font-size:0;}#yiv5405773197 #yiv5405773197photos div {float:left;width:72px;}#yiv5405773197 #yiv5405773197photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5405773197 #yiv5405773197photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5405773197 #yiv5405773197reco-category {font-size:77%;}#yiv5405773197 #yiv5405773197reco-desc {font-size:77%;}#yiv5405773197 .yiv5405773197replbq {margin:4px;}#yiv5405773197 #yiv5405773197ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5405773197 #yiv5405773197ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5405773197 #yiv5405773197ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5405773197 #yiv5405773197ygrp-mlmsg select, #yiv5405773197 input, #yiv5405773197 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5405773197 #yiv5405773197ygrp-mlmsg pre, #yiv5405773197 code {font:115% monospace;}#yiv5405773197 #yiv5405773197ygrp-mlmsg * {line-height:1.22em;}#yiv5405773197 #yiv5405773197ygrp-mlmsg #yiv5405773197logo {padding-bottom:10px;}#yiv5405773197 #yiv5405773197ygrp-msg p a {font-family:Verdana;}#yiv5405773197 #yiv5405773197ygrp-msg p#yiv5405773197attach-count span {color:#1E66AE;font-weight:700;}#yiv5405773197 #yiv5405773197ygrp-reco #yiv5405773197reco-head {color:#ff7900;font-weight:700;}#yiv5405773197 #yiv5405773197ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5405773197 #yiv5405773197ygrp-sponsor #yiv5405773197ov li a {font-size:130%;text-decoration:none;}#yiv5405773197 #yiv5405773197ygrp-sponsor #yiv5405773197ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5405773197 #yiv5405773197ygrp-sponsor #yiv5405773197ov ul {margin:0;padding:0 0 0 8px;}#yiv5405773197 #yiv5405773197ygrp-text {font-family:Georgia;}#yiv5405773197 #yiv5405773197ygrp-text p {margin:0 0 1em 0;}#yiv5405773197 #yiv5405773197ygrp-text tt {font-size:120%;}#yiv5405773197 #yiv5405773197ygrp-vital ul li:last-child {border-right:none !important;}#yiv5405773197