coba pake formula:
=COUNTIF($A$4:$A$23,A4)-(COUNTIF(A4:$A$23,A4))+1di tempatkan di Cell B4
TerimaKasih
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
#yiv4045823126 #yiv4045823126 -- #yiv4045823126ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4045823126
#yiv4045823126ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4045823126
#yiv4045823126ygrp-mkp #yiv4045823126hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4045823126 #yiv4045823126ygrp-mkp #yiv4045823126ads
{margin-bottom:10px;}#yiv4045823126 #yiv4045823126ygrp-mkp .yiv4045823126ad
{padding:0 0;}#yiv4045823126 #yiv4045823126ygrp-mkp .yiv4045823126ad p
{margin:0;}#yiv4045823126 #yiv4045823126ygrp-mkp .yiv4045823126ad a
{color:#0000ff;text-decoration:none;}#yiv4045823126 #yiv4045823126ygrp-sponsor
#yiv4045823126ygrp-lc {font-family:Arial;}#yiv4045823126
#yiv4045823126ygrp-sponsor #yiv4045823126ygrp-lc #yiv4045823126hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4045823126
#yiv4045823126ygrp-sponsor #yiv4045823126ygrp-lc .yiv4045823126ad
{margin-bottom:10px;padding:0 0;}#yiv4045823126 #yiv4045823126actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4045823126
#yiv4045823126activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4045823126
#yiv4045823126activity span {font-weight:700;}#yiv4045823126
#yiv4045823126activity span:first-child
{text-transform:uppercase;}#yiv4045823126 #yiv4045823126activity span a
{color:#5085b6;text-decoration:none;}#yiv4045823126 #yiv4045823126activity span
span {color:#ff7900;}#yiv4045823126 #yiv4045823126activity span
.yiv4045823126underline {text-decoration:underline;}#yiv4045823126
.yiv4045823126attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4045823126 .yiv4045823126attach div a
{text-decoration:none;}#yiv4045823126 .yiv4045823126attach img
{border:none;padding-right:5px;}#yiv4045823126 .yiv4045823126attach label
{display:block;margin-bottom:5px;}#yiv4045823126 .yiv4045823126attach label a
{text-decoration:none;}#yiv4045823126 blockquote {margin:0 0 0
4px;}#yiv4045823126 .yiv4045823126bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4045823126
.yiv4045823126bold a {text-decoration:none;}#yiv4045823126 dd.yiv4045823126last
p a {font-family:Verdana;font-weight:700;}#yiv4045823126 dd.yiv4045823126last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4045823126
dd.yiv4045823126last p span.yiv4045823126yshortcuts
{margin-right:0;}#yiv4045823126 div.yiv4045823126attach-table div div a
{text-decoration:none;}#yiv4045823126 div.yiv4045823126attach-table
{width:400px;}#yiv4045823126 div.yiv4045823126file-title a, #yiv4045823126
div.yiv4045823126file-title a:active, #yiv4045823126
div.yiv4045823126file-title a:hover, #yiv4045823126 div.yiv4045823126file-title
a:visited {text-decoration:none;}#yiv4045823126 div.yiv4045823126photo-title a,
#yiv4045823126 div.yiv4045823126photo-title a:active, #yiv4045823126
div.yiv4045823126photo-title a:hover, #yiv4045823126
div.yiv4045823126photo-title a:visited {text-decoration:none;}#yiv4045823126
div#yiv4045823126ygrp-mlmsg #yiv4045823126ygrp-msg p a
span.yiv4045823126yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4045823126
.yiv4045823126green {color:#628c2a;}#yiv4045823126 .yiv4045823126MsoNormal
{margin:0 0 0 0;}#yiv4045823126 o {font-size:0;}#yiv4045823126
#yiv4045823126photos div {float:left;width:72px;}#yiv4045823126
#yiv4045823126photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4045823126
#yiv4045823126photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4045823126
#yiv4045823126reco-category {font-size:77%;}#yiv4045823126
#yiv4045823126reco-desc {font-size:77%;}#yiv4045823126 .yiv4045823126replbq
{margin:4px;}#yiv4045823126 #yiv4045823126ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4045823126 #yiv4045823126ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4045823126
#yiv4045823126ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4045823126
#yiv4045823126ygrp-mlmsg select, #yiv4045823126 input, #yiv4045823126 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4045823126
#yiv4045823126ygrp-mlmsg pre, #yiv4045823126 code {font:115%
monospace;}#yiv4045823126 #yiv4045823126ygrp-mlmsg *
{line-height:1.22em;}#yiv4045823126 #yiv4045823126ygrp-mlmsg #yiv4045823126logo
{padding-bottom:10px;}#yiv4045823126 #yiv4045823126ygrp-msg p a
{font-family:Verdana;}#yiv4045823126 #yiv4045823126ygrp-msg
p#yiv4045823126attach-count span {color:#1E66AE;font-weight:700;}#yiv4045823126
#yiv4045823126ygrp-reco #yiv4045823126reco-head
{color:#ff7900;font-weight:700;}#yiv4045823126 #yiv4045823126ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4045823126 #yiv4045823126ygrp-sponsor
#yiv4045823126ov li a {font-size:130%;text-decoration:none;}#yiv4045823126
#yiv4045823126ygrp-sponsor #yiv4045823126ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4045823126
#yiv4045823126ygrp-sponsor #yiv4045823126ov ul {margin:0;padding:0 0 0
8px;}#yiv4045823126 #yiv4045823126ygrp-text
{font-family:Georgia;}#yiv4045823126 #yiv4045823126ygrp-text p {margin:0 0 1em
0;}#yiv4045823126 #yiv4045823126ygrp-text tt {font-size:120%;}#yiv4045823126
#yiv4045823126ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4045823126
