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 pmaho_l...@nabatisnack.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis: Judul: RE: [belajar-excel] Ambil Header dari data Kepada: belajar-excel@yahoogroups.com 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 erwanto_a...@yahoo.co.id [belajar-excel] [mailto:belajar-excel@yahoogroups.com] Sent: 29 Januari 2015 12:31 To: belajar-excel@yahoogroups.com 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