Mohon bantuannya sedikit lg suhu mr. kid, setelah saya melakukan seperti yg bpk katakan.. formulanya berjalan.. namun ada sedikit kendalala... (masalah pembulatan) file terlampir. regards.
Pada Kamis, 27 November 2014 9:30, "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: oh begitu... bagaimana kalau begini : 0. buka file lampiran dari saya tempo lalu (ada dua sheet kan) 1. buat sheet baru (bisa gak membuat sheet baru alias menambah sheet kosong dalam sebuah workbook ?) >> kalau gak bisa,coba lihat daftar sheet (persis dibawah sheet) [namanya tab sheets] -> klik yang paling kanan berbunyi Insert Worksheet kalau mousenya digerakkan ke arahnya 2. copy paste tabel referensi (yang ada di salah satu sheet) ke sheet baru itu. 3. lihat sheet lama (bukan yang baru) pada salah satu cell berformula vlookup 4. ubah rujukan range dalam formula vlookup itu ke tabel referensi yang ada di sheet baru tadi (jangan lupa untuk meng-absolute rujukan ke tabel referensi di sheet baru itu, bisa kan, yak betul, yang pencet tombol F4 di keyboard supaya tanda '$' dollar nya pindah-pindah sampai keluar 4 bijik tanda '$' dollar...) 5. selesai jika Anda sudah tahu cara membuat formula di Excel (misal formula =a7 dsb, jika belum bisa membuat formula seperti =a7, maka sebaiknya mengenal Excel lebih dulu). Wassalam, Kid. On Thu, Nov 27, 2014 at 1:18 PM, Pukka Hamonangan Pardede angan_l...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote: nah.. seperti itu yg ada di kepala saya gan.. masalahnya.. saya tidak tahu membuat yg seperti itu.. (maaf)sekiranya suhu berkenan memberikan penerapannya pada file terlampir sebelumnya (file terlampir "real converting) Pada Kamis, 27 November 2014 2:28, "'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Letakkan saja tabel referensi nya pada sebuah sheet tersendiri. Formula merujuk ke sheet khusus tersebut. Sheet khusus tersebut di-hide. Akhirnya, jadi seperti tabel referensi yang disimpan di kepala bukan ? Sama-sama ndak kelihatan tapi ada. Wassalam, Kid. 2014-11-27 3:57 GMT+11:00 angan_l...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>: terimakasih atas respon nya Suhu Mr.kidmaksut saya begini, ketentuan nilai dan konversinya kita simpan di kepala.. (ketentuan konversi tadi tidak disertakan dalam lembar kerja) file terlampir,regards. #yiv7091841154 #yiv7091841154 -- #yiv7091841154ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7091841154 #yiv7091841154ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7091841154 #yiv7091841154ygrp-mkp #yiv7091841154hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7091841154 #yiv7091841154ygrp-mkp #yiv7091841154ads {margin-bottom:10px;}#yiv7091841154 #yiv7091841154ygrp-mkp .yiv7091841154ad {padding:0 0;}#yiv7091841154 #yiv7091841154ygrp-mkp .yiv7091841154ad p {margin:0;}#yiv7091841154 #yiv7091841154ygrp-mkp .yiv7091841154ad a {color:#0000ff;text-decoration:none;}#yiv7091841154 #yiv7091841154ygrp-sponsor #yiv7091841154ygrp-lc {font-family:Arial;}#yiv7091841154 #yiv7091841154ygrp-sponsor #yiv7091841154ygrp-lc #yiv7091841154hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7091841154 #yiv7091841154ygrp-sponsor #yiv7091841154ygrp-lc .yiv7091841154ad {margin-bottom:10px;padding:0 0;}#yiv7091841154 #yiv7091841154actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7091841154 #yiv7091841154activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7091841154 #yiv7091841154activity span {font-weight:700;}#yiv7091841154 #yiv7091841154activity span:first-child {text-transform:uppercase;}#yiv7091841154 #yiv7091841154activity span a {color:#5085b6;text-decoration:none;}#yiv7091841154 #yiv7091841154activity span span {color:#ff7900;}#yiv7091841154 #yiv7091841154activity span .yiv7091841154underline {text-decoration:underline;}#yiv7091841154 .yiv7091841154attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7091841154 .yiv7091841154attach div a {text-decoration:none;}#yiv7091841154 .yiv7091841154attach img {border:none;padding-right:5px;}#yiv7091841154 .yiv7091841154attach label {display:block;margin-bottom:5px;}#yiv7091841154 .yiv7091841154attach label a {text-decoration:none;}#yiv7091841154 blockquote {margin:0 0 0 4px;}#yiv7091841154 .yiv7091841154bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7091841154 .yiv7091841154bold a {text-decoration:none;}#yiv7091841154 dd.yiv7091841154last p a {font-family:Verdana;font-weight:700;}#yiv7091841154 dd.yiv7091841154last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7091841154 dd.yiv7091841154last p span.yiv7091841154yshortcuts {margin-right:0;}#yiv7091841154 div.yiv7091841154attach-table div div a {text-decoration:none;}#yiv7091841154 div.yiv7091841154attach-table {width:400px;}#yiv7091841154 div.yiv7091841154file-title a, #yiv7091841154 div.yiv7091841154file-title a:active, #yiv7091841154 div.yiv7091841154file-title a:hover, #yiv7091841154 div.yiv7091841154file-title a:visited {text-decoration:none;}#yiv7091841154 div.yiv7091841154photo-title a, #yiv7091841154 div.yiv7091841154photo-title a:active, #yiv7091841154 div.yiv7091841154photo-title a:hover, #yiv7091841154 div.yiv7091841154photo-title a:visited {text-decoration:none;}#yiv7091841154 div#yiv7091841154ygrp-mlmsg #yiv7091841154ygrp-msg p a span.yiv7091841154yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7091841154 .yiv7091841154green {color:#628c2a;}#yiv7091841154 .yiv7091841154MsoNormal {margin:0 0 0 0;}#yiv7091841154 o {font-size:0;}#yiv7091841154 #yiv7091841154photos div {float:left;width:72px;}#yiv7091841154 #yiv7091841154photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7091841154 #yiv7091841154photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7091841154 #yiv7091841154reco-category {font-size:77%;}#yiv7091841154 #yiv7091841154reco-desc {font-size:77%;}#yiv7091841154 .yiv7091841154replbq {margin:4px;}#yiv7091841154 #yiv7091841154ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7091841154 #yiv7091841154ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7091841154 #yiv7091841154ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7091841154 #yiv7091841154ygrp-mlmsg select, #yiv7091841154 input, #yiv7091841154 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7091841154 #yiv7091841154ygrp-mlmsg pre, #yiv7091841154 code {font:115% monospace;}#yiv7091841154 #yiv7091841154ygrp-mlmsg * {line-height:1.22em;}#yiv7091841154 #yiv7091841154ygrp-mlmsg #yiv7091841154logo {padding-bottom:10px;}#yiv7091841154 #yiv7091841154ygrp-msg p a {font-family:Verdana;}#yiv7091841154 #yiv7091841154ygrp-msg p#yiv7091841154attach-count span {color:#1E66AE;font-weight:700;}#yiv7091841154 #yiv7091841154ygrp-reco #yiv7091841154reco-head {color:#ff7900;font-weight:700;}#yiv7091841154 #yiv7091841154ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7091841154 #yiv7091841154ygrp-sponsor #yiv7091841154ov li a {font-size:130%;text-decoration:none;}#yiv7091841154 #yiv7091841154ygrp-sponsor #yiv7091841154ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7091841154 #yiv7091841154ygrp-sponsor #yiv7091841154ov ul {margin:0;padding:0 0 0 8px;}#yiv7091841154 #yiv7091841154ygrp-text {font-family:Georgia;}#yiv7091841154 #yiv7091841154ygrp-text p {margin:0 0 1em 0;}#yiv7091841154 #yiv7091841154ygrp-text tt {font-size:120%;}#yiv7091841154 #yiv7091841154ygrp-vital ul li:last-child {border-right:none !important;}#yiv7091841154
nilai ketrampilan k13 kls xiwith formula.xlsx
Description: MS-Excel 2007 spreadsheet