yoo andreas, bisa pelajari di coretan mr. kid di sini. dan untuk kasus anda bisa diliat solusi yang pake banyak kolom bantu, klo ga mau pake kolom bantu itu bisa di masukin keformula yang ada di "total kode jaminan". br,
odong nando
Pada Selasa, 15 Desember 2015 11:39, "Andreas And [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Para Master Be-Exceller,Mohon bantuan dari para master untuk kasus
excel berikut. Mencari nilai yang mana hasilnya lebih dari 1 record.Mohon
bantuannya.Salam,
Andreas #yiv0283087061 #yiv0283087061 -- #yiv0283087061ygrp-mkp {border:1px
solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0283087061
#yiv0283087061ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0283087061
#yiv0283087061ygrp-mkp #yiv0283087061hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0283087061 #yiv0283087061ygrp-mkp #yiv0283087061ads
{margin-bottom:10px;}#yiv0283087061 #yiv0283087061ygrp-mkp .yiv0283087061ad
{padding:0 0;}#yiv0283087061 #yiv0283087061ygrp-mkp .yiv0283087061ad p
{margin:0;}#yiv0283087061 #yiv0283087061ygrp-mkp .yiv0283087061ad a
{color:#0000ff;text-decoration:none;}#yiv0283087061 #yiv0283087061ygrp-sponsor
#yiv0283087061ygrp-lc {font-family:Arial;}#yiv0283087061
#yiv0283087061ygrp-sponsor #yiv0283087061ygrp-lc #yiv0283087061hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0283087061
#yiv0283087061ygrp-sponsor #yiv0283087061ygrp-lc .yiv0283087061ad
{margin-bottom:10px;padding:0 0;}#yiv0283087061 #yiv0283087061actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0283087061
#yiv0283087061activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0283087061
#yiv0283087061activity span {font-weight:700;}#yiv0283087061
#yiv0283087061activity span:first-child
{text-transform:uppercase;}#yiv0283087061 #yiv0283087061activity span a
{color:#5085b6;text-decoration:none;}#yiv0283087061 #yiv0283087061activity span
span {color:#ff7900;}#yiv0283087061 #yiv0283087061activity span
.yiv0283087061underline {text-decoration:underline;}#yiv0283087061
.yiv0283087061attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0283087061 .yiv0283087061attach div a
{text-decoration:none;}#yiv0283087061 .yiv0283087061attach img
{border:none;padding-right:5px;}#yiv0283087061 .yiv0283087061attach label
{display:block;margin-bottom:5px;}#yiv0283087061 .yiv0283087061attach label a
{text-decoration:none;}#yiv0283087061 blockquote {margin:0 0 0
4px;}#yiv0283087061 .yiv0283087061bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0283087061
.yiv0283087061bold a {text-decoration:none;}#yiv0283087061 dd.yiv0283087061last
p a {font-family:Verdana;font-weight:700;}#yiv0283087061 dd.yiv0283087061last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0283087061
dd.yiv0283087061last p span.yiv0283087061yshortcuts
{margin-right:0;}#yiv0283087061 div.yiv0283087061attach-table div div a
{text-decoration:none;}#yiv0283087061 div.yiv0283087061attach-table
{width:400px;}#yiv0283087061 div.yiv0283087061file-title a, #yiv0283087061
div.yiv0283087061file-title a:active, #yiv0283087061
div.yiv0283087061file-title a:hover, #yiv0283087061 div.yiv0283087061file-title
a:visited {text-decoration:none;}#yiv0283087061 div.yiv0283087061photo-title a,
#yiv0283087061 div.yiv0283087061photo-title a:active, #yiv0283087061
div.yiv0283087061photo-title a:hover, #yiv0283087061
div.yiv0283087061photo-title a:visited {text-decoration:none;}#yiv0283087061
div#yiv0283087061ygrp-mlmsg #yiv0283087061ygrp-msg p a
span.yiv0283087061yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0283087061
.yiv0283087061green {color:#628c2a;}#yiv0283087061 .yiv0283087061MsoNormal
{margin:0 0 0 0;}#yiv0283087061 o {font-size:0;}#yiv0283087061
#yiv0283087061photos div {float:left;width:72px;}#yiv0283087061
#yiv0283087061photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0283087061
#yiv0283087061photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0283087061
#yiv0283087061reco-category {font-size:77%;}#yiv0283087061
#yiv0283087061reco-desc {font-size:77%;}#yiv0283087061 .yiv0283087061replbq
{margin:4px;}#yiv0283087061 #yiv0283087061ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0283087061 #yiv0283087061ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0283087061
#yiv0283087061ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0283087061
#yiv0283087061ygrp-mlmsg select, #yiv0283087061 input, #yiv0283087061 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0283087061
#yiv0283087061ygrp-mlmsg pre, #yiv0283087061 code {font:115%
monospace;}#yiv0283087061 #yiv0283087061ygrp-mlmsg *
{line-height:1.22em;}#yiv0283087061 #yiv0283087061ygrp-mlmsg #yiv0283087061logo
{padding-bottom:10px;}#yiv0283087061 #yiv0283087061ygrp-msg p a
{font-family:Verdana;}#yiv0283087061 #yiv0283087061ygrp-msg
p#yiv0283087061attach-count span {color:#1E66AE;font-weight:700;}#yiv0283087061
#yiv0283087061ygrp-reco #yiv0283087061reco-head
{color:#ff7900;font-weight:700;}#yiv0283087061 #yiv0283087061ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0283087061 #yiv0283087061ygrp-sponsor
#yiv0283087061ov li a {font-size:130%;text-decoration:none;}#yiv0283087061
#yiv0283087061ygrp-sponsor #yiv0283087061ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0283087061
#yiv0283087061ygrp-sponsor #yiv0283087061ov ul {margin:0;padding:0 0 0
8px;}#yiv0283087061 #yiv0283087061ygrp-text
{font-family:Georgia;}#yiv0283087061 #yiv0283087061ygrp-text p {margin:0 0 1em
0;}#yiv0283087061 #yiv0283087061ygrp-text tt {font-size:120%;}#yiv0283087061
#yiv0283087061ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0283087061
Rekap Member (Mencari dengan hasil yang lebih dari 1)-1.xlsx
Description: MS-Excel 2007 spreadsheet
