walaikum salam wr wb
kalau data sudah urut
coba di c4 tulis formula
=COUNTIF(A4:$A$4,A4)
salamlb
Pada Rabu, 18 Mei 2016 13:06, "[email protected] [belajar-excel]"
<[email protected]> menulis:
Assalaamu'alaikum Wr Wb
Yth. Para Master Excel
Mohon bantuan solusinya .. bagaimana caranya membuat rumus excel nomer urut
otomatis restart sesuai kriteria tertentu.
file kasus terlampir
Terima kasih
Wassalaamu'alaikum wr wb
#yiv8800247726 #yiv8800247726 -- #yiv8800247726ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8800247726
#yiv8800247726ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8800247726
#yiv8800247726ygrp-mkp #yiv8800247726hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8800247726 #yiv8800247726ygrp-mkp #yiv8800247726ads
{margin-bottom:10px;}#yiv8800247726 #yiv8800247726ygrp-mkp .yiv8800247726ad
{padding:0 0;}#yiv8800247726 #yiv8800247726ygrp-mkp .yiv8800247726ad p
{margin:0;}#yiv8800247726 #yiv8800247726ygrp-mkp .yiv8800247726ad a
{color:#0000ff;text-decoration:none;}#yiv8800247726 #yiv8800247726ygrp-sponsor
#yiv8800247726ygrp-lc {font-family:Arial;}#yiv8800247726
#yiv8800247726ygrp-sponsor #yiv8800247726ygrp-lc #yiv8800247726hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8800247726
#yiv8800247726ygrp-sponsor #yiv8800247726ygrp-lc .yiv8800247726ad
{margin-bottom:10px;padding:0 0;}#yiv8800247726 #yiv8800247726actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8800247726
#yiv8800247726activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8800247726
#yiv8800247726activity span {font-weight:700;}#yiv8800247726
#yiv8800247726activity span:first-child
{text-transform:uppercase;}#yiv8800247726 #yiv8800247726activity span a
{color:#5085b6;text-decoration:none;}#yiv8800247726 #yiv8800247726activity span
span {color:#ff7900;}#yiv8800247726 #yiv8800247726activity span
.yiv8800247726underline {text-decoration:underline;}#yiv8800247726
.yiv8800247726attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8800247726 .yiv8800247726attach div a
{text-decoration:none;}#yiv8800247726 .yiv8800247726attach img
{border:none;padding-right:5px;}#yiv8800247726 .yiv8800247726attach label
{display:block;margin-bottom:5px;}#yiv8800247726 .yiv8800247726attach label a
{text-decoration:none;}#yiv8800247726 blockquote {margin:0 0 0
4px;}#yiv8800247726 .yiv8800247726bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8800247726
.yiv8800247726bold a {text-decoration:none;}#yiv8800247726 dd.yiv8800247726last
p a {font-family:Verdana;font-weight:700;}#yiv8800247726 dd.yiv8800247726last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8800247726
dd.yiv8800247726last p span.yiv8800247726yshortcuts
{margin-right:0;}#yiv8800247726 div.yiv8800247726attach-table div div a
{text-decoration:none;}#yiv8800247726 div.yiv8800247726attach-table
{width:400px;}#yiv8800247726 div.yiv8800247726file-title a, #yiv8800247726
div.yiv8800247726file-title a:active, #yiv8800247726
div.yiv8800247726file-title a:hover, #yiv8800247726 div.yiv8800247726file-title
a:visited {text-decoration:none;}#yiv8800247726 div.yiv8800247726photo-title a,
#yiv8800247726 div.yiv8800247726photo-title a:active, #yiv8800247726
div.yiv8800247726photo-title a:hover, #yiv8800247726
div.yiv8800247726photo-title a:visited {text-decoration:none;}#yiv8800247726
div#yiv8800247726ygrp-mlmsg #yiv8800247726ygrp-msg p a
span.yiv8800247726yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8800247726
.yiv8800247726green {color:#628c2a;}#yiv8800247726 .yiv8800247726MsoNormal
{margin:0 0 0 0;}#yiv8800247726 o {font-size:0;}#yiv8800247726
#yiv8800247726photos div {float:left;width:72px;}#yiv8800247726
#yiv8800247726photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8800247726
#yiv8800247726photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8800247726
#yiv8800247726reco-category {font-size:77%;}#yiv8800247726
#yiv8800247726reco-desc {font-size:77%;}#yiv8800247726 .yiv8800247726replbq
{margin:4px;}#yiv8800247726 #yiv8800247726ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8800247726 #yiv8800247726ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8800247726
#yiv8800247726ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8800247726
#yiv8800247726ygrp-mlmsg select, #yiv8800247726 input, #yiv8800247726 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8800247726
#yiv8800247726ygrp-mlmsg pre, #yiv8800247726 code {font:115%
monospace;}#yiv8800247726 #yiv8800247726ygrp-mlmsg *
{line-height:1.22em;}#yiv8800247726 #yiv8800247726ygrp-mlmsg #yiv8800247726logo
{padding-bottom:10px;}#yiv8800247726 #yiv8800247726ygrp-msg p a
{font-family:Verdana;}#yiv8800247726 #yiv8800247726ygrp-msg
p#yiv8800247726attach-count span {color:#1E66AE;font-weight:700;}#yiv8800247726
#yiv8800247726ygrp-reco #yiv8800247726reco-head
{color:#ff7900;font-weight:700;}#yiv8800247726 #yiv8800247726ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8800247726 #yiv8800247726ygrp-sponsor
#yiv8800247726ov li a {font-size:130%;text-decoration:none;}#yiv8800247726
#yiv8800247726ygrp-sponsor #yiv8800247726ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8800247726
#yiv8800247726ygrp-sponsor #yiv8800247726ov ul {margin:0;padding:0 0 0
8px;}#yiv8800247726 #yiv8800247726ygrp-text
{font-family:Georgia;}#yiv8800247726 #yiv8800247726ygrp-text p {margin:0 0 1em
0;}#yiv8800247726 #yiv8800247726ygrp-text tt {font-size:120%;}#yiv8800247726
#yiv8800247726ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8800247726
