ok, terima kasih, ini file nya sudah saya perbaiki
On Tuesday, November 24, 2015 11:10 PM, "Gustia Liani
gustialiani_mat...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
wrote:
--- Mods ---
File Excel bertipe xlsx,xlsm, atau xlsb tidak akan berdampak banyak dengan di
zip, rar, atau 7z karena memang sudah berupa file terkompresi.
Dimohon, lain kali, kurangi jumlah baris datanya agar ukuran file lampiran
menjadi lebih sesuai dengan peraturan milis Belajar-Excel
----------------
On Tuesday, November 24, 2015 11:01 PM, "Gustia Liani
gustialiani_mat...@yahoo.com [belajar-excel]" wrote:
saya lampirkan kembali, sumber data (ishiknas.rar) dan format yang ingin
saya buat (form).
On Tuesday, November 24, 2015 8:55 PM, "gustialiani_mat...@yahoo.com
[belajar-excel]" wrote:
Pak, saya mau bertanya,saya mempunyai data ishiknas (sebagaimana
terlampir). saya ingin membuat seperti format di sheet form, yang semua nya
menggunakan rumus/fungsi excel, mohon bantuan nya.Terima kasih
--- Mods ---File lampiran yang melebihi 250KB dilepas dari email. Silakan
penanya melakukan posting ulang file lampiran yang ukurannya diusahakan
maksimal 250KB dengan cara me-reply email ini.----------------
#yiv7037135785 #yiv7037135785 -- #yiv7037135785ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7037135785
#yiv7037135785ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7037135785
#yiv7037135785ygrp-mkp #yiv7037135785hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7037135785 #yiv7037135785ygrp-mkp #yiv7037135785ads
{margin-bottom:10px;}#yiv7037135785 #yiv7037135785ygrp-mkp .yiv7037135785ad
{padding:0 0;}#yiv7037135785 #yiv7037135785ygrp-mkp .yiv7037135785ad p
{margin:0;}#yiv7037135785 #yiv7037135785ygrp-mkp .yiv7037135785ad a
{color:#0000ff;text-decoration:none;}#yiv7037135785 #yiv7037135785ygrp-sponsor
#yiv7037135785ygrp-lc {font-family:Arial;}#yiv7037135785
#yiv7037135785ygrp-sponsor #yiv7037135785ygrp-lc #yiv7037135785hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7037135785
#yiv7037135785ygrp-sponsor #yiv7037135785ygrp-lc .yiv7037135785ad
{margin-bottom:10px;padding:0 0;}#yiv7037135785 #yiv7037135785actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7037135785
#yiv7037135785activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7037135785
#yiv7037135785activity span {font-weight:700;}#yiv7037135785
#yiv7037135785activity span:first-child
{text-transform:uppercase;}#yiv7037135785 #yiv7037135785activity span a
{color:#5085b6;text-decoration:none;}#yiv7037135785 #yiv7037135785activity span
span {color:#ff7900;}#yiv7037135785 #yiv7037135785activity span
.yiv7037135785underline {text-decoration:underline;}#yiv7037135785
.yiv7037135785attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7037135785 .yiv7037135785attach div a
{text-decoration:none;}#yiv7037135785 .yiv7037135785attach img
{border:none;padding-right:5px;}#yiv7037135785 .yiv7037135785attach label
{display:block;margin-bottom:5px;}#yiv7037135785 .yiv7037135785attach label a
{text-decoration:none;}#yiv7037135785 blockquote {margin:0 0 0
4px;}#yiv7037135785 .yiv7037135785bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7037135785
.yiv7037135785bold a {text-decoration:none;}#yiv7037135785 dd.yiv7037135785last
p a {font-family:Verdana;font-weight:700;}#yiv7037135785 dd.yiv7037135785last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7037135785
dd.yiv7037135785last p span.yiv7037135785yshortcuts
{margin-right:0;}#yiv7037135785 div.yiv7037135785attach-table div div a
{text-decoration:none;}#yiv7037135785 div.yiv7037135785attach-table
{width:400px;}#yiv7037135785 div.yiv7037135785file-title a, #yiv7037135785
div.yiv7037135785file-title a:active, #yiv7037135785
div.yiv7037135785file-title a:hover, #yiv7037135785 div.yiv7037135785file-title
a:visited {text-decoration:none;}#yiv7037135785 div.yiv7037135785photo-title a,
#yiv7037135785 div.yiv7037135785photo-title a:active, #yiv7037135785
div.yiv7037135785photo-title a:hover, #yiv7037135785
div.yiv7037135785photo-title a:visited {text-decoration:none;}#yiv7037135785
div#yiv7037135785ygrp-mlmsg #yiv7037135785ygrp-msg p a
span.yiv7037135785yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7037135785
.yiv7037135785green {color:#628c2a;}#yiv7037135785 .yiv7037135785MsoNormal
{margin:0 0 0 0;}#yiv7037135785 o {font-size:0;}#yiv7037135785
#yiv7037135785photos div {float:left;width:72px;}#yiv7037135785
#yiv7037135785photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7037135785
#yiv7037135785photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7037135785
#yiv7037135785reco-category {font-size:77%;}#yiv7037135785
#yiv7037135785reco-desc {font-size:77%;}#yiv7037135785 .yiv7037135785replbq
{margin:4px;}#yiv7037135785 #yiv7037135785ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7037135785 #yiv7037135785ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7037135785
#yiv7037135785ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7037135785
#yiv7037135785ygrp-mlmsg select, #yiv7037135785 input, #yiv7037135785 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7037135785
#yiv7037135785ygrp-mlmsg pre, #yiv7037135785 code {font:115%
monospace;}#yiv7037135785 #yiv7037135785ygrp-mlmsg *
{line-height:1.22em;}#yiv7037135785 #yiv7037135785ygrp-mlmsg #yiv7037135785logo
{padding-bottom:10px;}#yiv7037135785 #yiv7037135785ygrp-msg p a
{font-family:Verdana;}#yiv7037135785 #yiv7037135785ygrp-msg
p#yiv7037135785attach-count span {color:#1E66AE;font-weight:700;}#yiv7037135785
#yiv7037135785ygrp-reco #yiv7037135785reco-head
{color:#ff7900;font-weight:700;}#yiv7037135785 #yiv7037135785ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7037135785 #yiv7037135785ygrp-sponsor
#yiv7037135785ov li a {font-size:130%;text-decoration:none;}#yiv7037135785
#yiv7037135785ygrp-sponsor #yiv7037135785ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7037135785
#yiv7037135785ygrp-sponsor #yiv7037135785ov ul {margin:0;padding:0 0 0
8px;}#yiv7037135785 #yiv7037135785ygrp-text
{font-family:Georgia;}#yiv7037135785 #yiv7037135785ygrp-text p {margin:0 0 1em
0;}#yiv7037135785 #yiv7037135785ygrp-text tt {font-size:120%;}#yiv7037135785
#yiv7037135785ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7037135785
data.xlsx
Description: MS-Excel 2007 spreadsheet
