yoo tjahya,
bisa kok pake gabungan vlookup & counta
=vlookup( "*" ; _range yang akan di cari_ ; counta ( _range yang akan di cari_
); false )
' bila regional setting kompi setempat english maka ubah karakter titik koma
";" menjadi koma ",".
br,
odong nando
Pada Kamis, 3 Desember 2015 12:26, "Tjahya Hartono
[email protected] [belajar-excel]" <[email protected]>
menulis:
Dear Master excel,
mohon petunjuknya untuk kasus ini para guru dan master excel,Bisakah saya hanya
mengambil bagian terakhirnya saja untuk dimasukkan dalam satu kolom saja karena
datanya ada ratusan, jadi bikin capek kalo manual mindahin satu-satu.
Terima kasih
Tjahy
#yiv9943431357 #yiv9943431357 -- #yiv9943431357ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9943431357
#yiv9943431357ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9943431357
#yiv9943431357ygrp-mkp #yiv9943431357hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9943431357 #yiv9943431357ygrp-mkp #yiv9943431357ads
{margin-bottom:10px;}#yiv9943431357 #yiv9943431357ygrp-mkp .yiv9943431357ad
{padding:0 0;}#yiv9943431357 #yiv9943431357ygrp-mkp .yiv9943431357ad p
{margin:0;}#yiv9943431357 #yiv9943431357ygrp-mkp .yiv9943431357ad a
{color:#0000ff;text-decoration:none;}#yiv9943431357 #yiv9943431357ygrp-sponsor
#yiv9943431357ygrp-lc {font-family:Arial;}#yiv9943431357
#yiv9943431357ygrp-sponsor #yiv9943431357ygrp-lc #yiv9943431357hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9943431357
#yiv9943431357ygrp-sponsor #yiv9943431357ygrp-lc .yiv9943431357ad
{margin-bottom:10px;padding:0 0;}#yiv9943431357 #yiv9943431357actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9943431357
#yiv9943431357activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9943431357
#yiv9943431357activity span {font-weight:700;}#yiv9943431357
#yiv9943431357activity span:first-child
{text-transform:uppercase;}#yiv9943431357 #yiv9943431357activity span a
{color:#5085b6;text-decoration:none;}#yiv9943431357 #yiv9943431357activity span
span {color:#ff7900;}#yiv9943431357 #yiv9943431357activity span
.yiv9943431357underline {text-decoration:underline;}#yiv9943431357
.yiv9943431357attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9943431357 .yiv9943431357attach div a
{text-decoration:none;}#yiv9943431357 .yiv9943431357attach img
{border:none;padding-right:5px;}#yiv9943431357 .yiv9943431357attach label
{display:block;margin-bottom:5px;}#yiv9943431357 .yiv9943431357attach label a
{text-decoration:none;}#yiv9943431357 blockquote {margin:0 0 0
4px;}#yiv9943431357 .yiv9943431357bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9943431357
.yiv9943431357bold a {text-decoration:none;}#yiv9943431357 dd.yiv9943431357last
p a {font-family:Verdana;font-weight:700;}#yiv9943431357 dd.yiv9943431357last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9943431357
dd.yiv9943431357last p span.yiv9943431357yshortcuts
{margin-right:0;}#yiv9943431357 div.yiv9943431357attach-table div div a
{text-decoration:none;}#yiv9943431357 div.yiv9943431357attach-table
{width:400px;}#yiv9943431357 div.yiv9943431357file-title a, #yiv9943431357
div.yiv9943431357file-title a:active, #yiv9943431357
div.yiv9943431357file-title a:hover, #yiv9943431357 div.yiv9943431357file-title
a:visited {text-decoration:none;}#yiv9943431357 div.yiv9943431357photo-title a,
#yiv9943431357 div.yiv9943431357photo-title a:active, #yiv9943431357
div.yiv9943431357photo-title a:hover, #yiv9943431357
div.yiv9943431357photo-title a:visited {text-decoration:none;}#yiv9943431357
div#yiv9943431357ygrp-mlmsg #yiv9943431357ygrp-msg p a
span.yiv9943431357yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9943431357
.yiv9943431357green {color:#628c2a;}#yiv9943431357 .yiv9943431357MsoNormal
{margin:0 0 0 0;}#yiv9943431357 o {font-size:0;}#yiv9943431357
#yiv9943431357photos div {float:left;width:72px;}#yiv9943431357
#yiv9943431357photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9943431357
#yiv9943431357photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9943431357
#yiv9943431357reco-category {font-size:77%;}#yiv9943431357
#yiv9943431357reco-desc {font-size:77%;}#yiv9943431357 .yiv9943431357replbq
{margin:4px;}#yiv9943431357 #yiv9943431357ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9943431357 #yiv9943431357ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9943431357
#yiv9943431357ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9943431357
#yiv9943431357ygrp-mlmsg select, #yiv9943431357 input, #yiv9943431357 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9943431357
#yiv9943431357ygrp-mlmsg pre, #yiv9943431357 code {font:115%
monospace;}#yiv9943431357 #yiv9943431357ygrp-mlmsg *
{line-height:1.22em;}#yiv9943431357 #yiv9943431357ygrp-mlmsg #yiv9943431357logo
{padding-bottom:10px;}#yiv9943431357 #yiv9943431357ygrp-msg p a
{font-family:Verdana;}#yiv9943431357 #yiv9943431357ygrp-msg
p#yiv9943431357attach-count span {color:#1E66AE;font-weight:700;}#yiv9943431357
#yiv9943431357ygrp-reco #yiv9943431357reco-head
{color:#ff7900;font-weight:700;}#yiv9943431357 #yiv9943431357ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9943431357 #yiv9943431357ygrp-sponsor
#yiv9943431357ov li a {font-size:130%;text-decoration:none;}#yiv9943431357
#yiv9943431357ygrp-sponsor #yiv9943431357ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9943431357
#yiv9943431357ygrp-sponsor #yiv9943431357ov ul {margin:0;padding:0 0 0
8px;}#yiv9943431357 #yiv9943431357ygrp-text
{font-family:Georgia;}#yiv9943431357 #yiv9943431357ygrp-text p {margin:0 0 1em
0;}#yiv9943431357 #yiv9943431357ygrp-text tt {font-size:120%;}#yiv9943431357
#yiv9943431357ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9943431357
