kalau pake formula ini gimana ya? saya dapat pe er yang mirip.. hehe.. punya
saya mah ada sebagian cell yang berisikan hanya angka
Pada Jum, 23 Feb 2018 pada 21:19, '..:: priel ::..' xavr...@gmail.com
[belajar-excel]<belajar-excel@yahoogroups.com> menulis:
Nambahin,
Kalau mau select kolomnya secara formula, bisa pakai formula offset
Maap pakai HP, nggak bisa kasih contoh
Salam
On Feb 21, 2018 9:49 PM, "Nangagus nanga...@gmail.com [belajar-excel]"
<belajar-excel@yahoogroups.com> wrote:
Deaar Riki,
Bagaimana jika digabungkan saja seluruh data.
misalnya di C3 diketik formula: =E3&F3&G3&H3&I3&J3
kemudian dikopi ke bawah.
On 20/02/2018 23:52, rickychiesa ricky45chi...@yahoo.co.id [belajar-excel]
wrote:
Selamat sore Para Masters,
Saya mau Tanya rumus seperti data di bawah, saya sedang cari rumus untuk dapat
kolom yang warna kuning, sesuai hasil di contoh.
Salam,
Riki Ahmad
Newbie Exceler
Sent from Mail for Windows 10
#yiv7344522459 #yiv7344522459 -- #yiv7344522459ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7344522459
#yiv7344522459ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7344522459
#yiv7344522459ygrp-mkp #yiv7344522459hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7344522459 #yiv7344522459ygrp-mkp #yiv7344522459ads
{margin-bottom:10px;}#yiv7344522459 #yiv7344522459ygrp-mkp .yiv7344522459ad
{padding:0 0;}#yiv7344522459 #yiv7344522459ygrp-mkp .yiv7344522459ad p
{margin:0;}#yiv7344522459 #yiv7344522459ygrp-mkp .yiv7344522459ad a
{color:#0000ff;text-decoration:none;}#yiv7344522459 #yiv7344522459ygrp-sponsor
#yiv7344522459ygrp-lc {font-family:Arial;}#yiv7344522459
#yiv7344522459ygrp-sponsor #yiv7344522459ygrp-lc #yiv7344522459hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7344522459
#yiv7344522459ygrp-sponsor #yiv7344522459ygrp-lc .yiv7344522459ad
{margin-bottom:10px;padding:0 0;}#yiv7344522459 #yiv7344522459actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7344522459
#yiv7344522459activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7344522459
#yiv7344522459activity span {font-weight:700;}#yiv7344522459
#yiv7344522459activity span:first-child
{text-transform:uppercase;}#yiv7344522459 #yiv7344522459activity span a
{color:#5085b6;text-decoration:none;}#yiv7344522459 #yiv7344522459activity span
span {color:#ff7900;}#yiv7344522459 #yiv7344522459activity span
.yiv7344522459underline {text-decoration:underline;}#yiv7344522459
.yiv7344522459attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7344522459 .yiv7344522459attach div a
{text-decoration:none;}#yiv7344522459 .yiv7344522459attach img
{border:none;padding-right:5px;}#yiv7344522459 .yiv7344522459attach label
{display:block;margin-bottom:5px;}#yiv7344522459 .yiv7344522459attach label a
{text-decoration:none;}#yiv7344522459 blockquote {margin:0 0 0
4px;}#yiv7344522459 .yiv7344522459bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7344522459
.yiv7344522459bold a {text-decoration:none;}#yiv7344522459 dd.yiv7344522459last
p a {font-family:Verdana;font-weight:700;}#yiv7344522459 dd.yiv7344522459last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7344522459
dd.yiv7344522459last p span.yiv7344522459yshortcuts
{margin-right:0;}#yiv7344522459 div.yiv7344522459attach-table div div a
{text-decoration:none;}#yiv7344522459 div.yiv7344522459attach-table
{width:400px;}#yiv7344522459 div.yiv7344522459file-title a, #yiv7344522459
div.yiv7344522459file-title a:active, #yiv7344522459
div.yiv7344522459file-title a:hover, #yiv7344522459 div.yiv7344522459file-title
a:visited {text-decoration:none;}#yiv7344522459 div.yiv7344522459photo-title a,
#yiv7344522459 div.yiv7344522459photo-title a:active, #yiv7344522459
div.yiv7344522459photo-title a:hover, #yiv7344522459
div.yiv7344522459photo-title a:visited {text-decoration:none;}#yiv7344522459
div#yiv7344522459ygrp-mlmsg #yiv7344522459ygrp-msg p a
span.yiv7344522459yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7344522459
.yiv7344522459green {color:#628c2a;}#yiv7344522459 .yiv7344522459MsoNormal
{margin:0 0 0 0;}#yiv7344522459 o {font-size:0;}#yiv7344522459
#yiv7344522459photos div {float:left;width:72px;}#yiv7344522459
#yiv7344522459photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv7344522459
#yiv7344522459photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7344522459
#yiv7344522459reco-category {font-size:77%;}#yiv7344522459
#yiv7344522459reco-desc {font-size:77%;}#yiv7344522459 .yiv7344522459replbq
{margin:4px;}#yiv7344522459 #yiv7344522459ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7344522459 #yiv7344522459ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7344522459
#yiv7344522459ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7344522459
#yiv7344522459ygrp-mlmsg select, #yiv7344522459 input, #yiv7344522459 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7344522459
#yiv7344522459ygrp-mlmsg pre, #yiv7344522459 code {font:115%
monospace;}#yiv7344522459 #yiv7344522459ygrp-mlmsg *
{line-height:1.22em;}#yiv7344522459 #yiv7344522459ygrp-mlmsg #yiv7344522459logo
{padding-bottom:10px;}#yiv7344522459 #yiv7344522459ygrp-msg p a
{font-family:Verdana;}#yiv7344522459 #yiv7344522459ygrp-msg
p#yiv7344522459attach-count span {color:#1E66AE;font-weight:700;}#yiv7344522459
#yiv7344522459ygrp-reco #yiv7344522459reco-head
{color:#ff7900;font-weight:700;}#yiv7344522459 #yiv7344522459ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7344522459 #yiv7344522459ygrp-sponsor
#yiv7344522459ov li a {font-size:130%;text-decoration:none;}#yiv7344522459
#yiv7344522459ygrp-sponsor #yiv7344522459ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7344522459
#yiv7344522459ygrp-sponsor #yiv7344522459ov ul {margin:0;padding:0 0 0
8px;}#yiv7344522459 #yiv7344522459ygrp-text
{font-family:Georgia;}#yiv7344522459 #yiv7344522459ygrp-text p {margin:0 0 1em
0;}#yiv7344522459 #yiv7344522459ygrp-text tt {font-size:120%;}#yiv7344522459
#yiv7344522459ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7344522459
