RE: [belajar-excel] Ambil Header dari data

Mon, 09 Feb 2015 02:38:08 -0800 


Hai Agus,





Kurang lebih terjemahannya seperti ini :





IF(ISNUMBER(B4);INDEX($B$3:$F$7;1;1)&";
";"")


รจ kalau cell B4 terisi angka, maka terisi cell B3 selain dari itu kosong


Jadi kalau cell itu terisi bukan oleh angka maka hasilnya kosong,


Begitu seterusnya.





Semoga dapat dipahami yah...





Salam,


DD





From: Agus Erwanto [email protected] [belajar-excel] 
[mailto:[email protected]]
Sent: 06 Februari 2015 11:30
To: [email protected]
Subject: RE: [belajar-excel] Ambil Header dari data








Terimaksih banyak pak DEDE,
bisakah saya di beritahukan untuk logikanya dalam bentuk tulisan, supaya bisa 
menerangkan dengan baik.


terimakasih


--------------------------------------------
Pada Rab, 4/2/15, Dede [email protected] [belajar-excel] 
<[email protected]> menulis:


Judul: RE: [belajar-excel] Ambil Header dari data
Kepada: [email protected]
Tanggal: Rabu, 4 Februari, 2015, 12:10 PM













Hai Agus,











Coba formula ini di
cell H4 :









=IF(ISNUMBER(B4);INDEX($B$3:$F$7;1;1)&";
";"")&IF(ISNUMBER(C4);INDEX($B$3:$F$7;1;2)&";
";"")&IF(ISNUMBER(D4);INDEX($B$3:$F$7;1;3)&";
";"")&IF(ISNUMBER(E4);INDEX($B$3:$F$7;1;4)&";
";"")&IF(ISNUMBER(F4);INDEX($B$3:$F$7;1;5)&";
";"")














Semoga sesuai
harapan.









DD





















From: Agus Erwanto
[email protected] [belajar-excel]
[mailto:[email protected]]




Sent: 29 Januari 2015 12:31


To: [email protected]


Subject: [belajar-excel] Ambil Header dari data [1
Attachment]












































Dear Team Excel,






selamat siang,


mohon bantuannya untuk kasus saya dibawah ini.






saya ingin mengandengkan header header yang ada datanya,
tidak masalah itu data
berisi anggak 1, 2, dll


jadi kalau ada data langsung diambil headernya.






utnuk keterangan lebih lanjut saya sertakan
attachmentnya.






regards,






terimakasih






agus erw



















































This e-mail and any files
transmitted with it are confidential and
intended solely for the use of the individual to whom it is
addressed. If you
have received this email in error please send it back to the
person that sent
it to you. Any views or opinions presented are solely those
of its author and
do not necessarily represent those of NABATI or any of its
subsidiary
companies. Unauthorized publication, use, dissemination,
forwarding, printing
or copying of this email and its associated attachments is
strictly prohibited.






































#yiv2677261378 #yiv2677261378 --
#yiv2677261378ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}


#yiv2677261378 #yiv2677261378ygrp-mkp hr {
border:1px solid #d8d8d8;}


#yiv2677261378 #yiv2677261378ygrp-mkp #yiv2677261378hd {


color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}


#yiv2677261378 #yiv2677261378ygrp-mkp #yiv2677261378ads {
margin-bottom:10px;}


#yiv2677261378 #yiv2677261378ygrp-mkp .yiv2677261378ad {
padding:0 0;}


#yiv2677261378 #yiv2677261378ygrp-mkp .yiv2677261378ad p {
margin:0;}



#yiv2677261378 #yiv2677261378ygrp-mkp .yiv2677261378ad a {
color:#0000ff;text-decoration:none;}
#yiv2677261378 #yiv2677261378ygrp-sponsor
#yiv2677261378ygrp-lc {
font-family:Arial;}


#yiv2677261378 #yiv2677261378ygrp-sponsor
#yiv2677261378ygrp-lc #yiv2677261378hd {
margin:10px


0px;font-weight:700;font-size:78%;line-height:122%;}


#yiv2677261378 #yiv2677261378ygrp-sponsor
#yiv2677261378ygrp-lc .yiv2677261378ad {
margin-bottom:10px;padding:0 0;}



#yiv2677261378 #yiv2677261378actions {
font-family:Verdana;font-size:11px;padding:10px 0;}


#yiv2677261378 #yiv2677261378activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}


#yiv2677261378 #yiv2677261378activity span {
font-weight:700;}


#yiv2677261378 #yiv2677261378activity span:first-child {
text-transform:uppercase;}


#yiv2677261378 #yiv2677261378activity span a {
color:#5085b6;text-decoration:none;}


#yiv2677261378 #yiv2677261378activity span span {
color:#ff7900;}


#yiv2677261378 #yiv2677261378activity span
.yiv2677261378underline {
text-decoration:underline;}


#yiv2677261378 .yiv2677261378attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}


#yiv2677261378 .yiv2677261378attach div a {
text-decoration:none;}


#yiv2677261378 .yiv2677261378attach img {
border:none;padding-right:5px;}


#yiv2677261378 .yiv2677261378attach label {
display:block;margin-bottom:5px;}


#yiv2677261378 .yiv2677261378attach label a {
text-decoration:none;}


#yiv2677261378 blockquote {
margin:0 0 0 4px;}


#yiv2677261378 .yiv2677261378bold {
font-family:Arial;font-size:13px;font-weight:700;}


#yiv2677261378 .yiv2677261378bold a {
text-decoration:none;}


#yiv2677261378 dd.yiv2677261378last p a {
font-family:Verdana;font-weight:700;}


#yiv2677261378 dd.yiv2677261378last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}


#yiv2677261378 dd.yiv2677261378last p
span.yiv2677261378yshortcuts {
margin-right:0;}


#yiv2677261378 div.yiv2677261378attach-table div div a {
text-decoration:none;}


#yiv2677261378 div.yiv2677261378attach-table {
width:400px;}


#yiv2677261378 div.yiv2677261378file-title a, #yiv2677261378
div.yiv2677261378file-title a:active, #yiv2677261378
div.yiv2677261378file-title a:hover, #yiv2677261378
div.yiv2677261378file-title a:visited {
text-decoration:none;}


#yiv2677261378 div.yiv2677261378photo-title a,
#yiv2677261378 div.yiv2677261378photo-title a:active,
#yiv2677261378 div.yiv2677261378photo-title a:hover,
#yiv2677261378 div.yiv2677261378photo-title a:visited {
text-decoration:none;}


#yiv2677261378 div#yiv2677261378ygrp-mlmsg
#yiv2677261378ygrp-msg p a span.yiv2677261378yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}


#yiv2677261378 .yiv2677261378green {
color:#628c2a;}


#yiv2677261378 .yiv2677261378MsoNormal {
margin:0 0 0 0;}


#yiv2677261378 o {
font-size:0;}


#yiv2677261378 #yiv2677261378photos div {
float:left;width:72px;}


#yiv2677261378 #yiv2677261378photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}


#yiv2677261378 #yiv2677261378photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}


#yiv2677261378 #yiv2677261378reco-category {
font-size:77%;}


#yiv2677261378 #yiv2677261378reco-desc {
font-size:77%;}


#yiv2677261378 .yiv2677261378replbq {
margin:4px;}


#yiv2677261378 #yiv2677261378ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}


#yiv2677261378 #yiv2677261378ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}


#yiv2677261378 #yiv2677261378ygrp-mlmsg table {
font-size:inherit;font:100%;}


#yiv2677261378 #yiv2677261378ygrp-mlmsg select,
#yiv2677261378 input, #yiv2677261378 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}


#yiv2677261378 #yiv2677261378ygrp-mlmsg pre, #yiv2677261378
code {
font:115% monospace;}


#yiv2677261378 #yiv2677261378ygrp-mlmsg * {
line-height:1.22em;}


#yiv2677261378 #yiv2677261378ygrp-mlmsg #yiv2677261378logo {
padding-bottom:10px;}




#yiv2677261378 #yiv2677261378ygrp-msg p a {
font-family:Verdana;}


#yiv2677261378 #yiv2677261378ygrp-msg
p#yiv2677261378attach-count span {
color:#1E66AE;font-weight:700;}


#yiv2677261378 #yiv2677261378ygrp-reco
#yiv2677261378reco-head {
color:#ff7900;font-weight:700;}


#yiv2677261378 #yiv2677261378ygrp-reco {
margin-bottom:20px;padding:0px;}


#yiv2677261378 #yiv2677261378ygrp-sponsor #yiv2677261378ov
li a {
font-size:130%;text-decoration:none;}


#yiv2677261378 #yiv2677261378ygrp-sponsor #yiv2677261378ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}


#yiv2677261378 #yiv2677261378ygrp-sponsor #yiv2677261378ov
ul {
margin:0;padding:0 0 0 8px;}


#yiv2677261378 #yiv2677261378ygrp-text {
font-family:Georgia;}


#yiv2677261378 #yiv2677261378ygrp-text p {
margin:0 0 1em 0;}


#yiv2677261378 #yiv2677261378ygrp-text tt {
font-size:120%;}


#yiv2677261378 #yiv2677261378ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv2677261378









  _____


This e-mail and any files transmitted with it are confidential and intended 
solely for the use of the individual to whom it is addressed. If you have 
received this email in error please send it back to the person that sent it to 
you. Any views or opinions presented are solely those of its author and do not 
necessarily represent those of NABATI or any of its subsidiary companies. 
Unauthorized publication, use, dissemination, forwarding, printing or copying 
of this email and its associated attachments is strictly prohibited.
























					Kirim email ke