yoo rian,
pada sheet pendaftaran bisa di siapkan header
NAMA | KELAS | JENIS LOMBA
ketik nama kelas dan jenis lomba pada setiap barisnya, bila akan memilih 2 maka
masukan lagi nama kelas dan jenis lomba (yang ke2). setelah itu blok semua data
termasuk header klik ribon insert pilih pivot table, pilih new worksheet ->
OK.pada sheet yang terdapat pivot table nya drak n drop fields JENIS LOMBA,
KELAS, NAMA secara berurutan pada row labels. atau klik kanan pada masing2
fields pilih row labels secara berurutan. maka akan tersusun seperti yang
diinginkan.
br,
odong nando
Pada Rabu, 23 Desember 2015 12:49, "Rian Sutarsa [email protected]
[belajar-excel]" <[email protected]> menulis:
salam pagi BExceller mohon penerangannya di pagi mendung ini.saya punya
gambaran permasalahan.di beberapa kelas ada pendaftaran beberapa perlombaan
(MTQ, Kaligrafi, Dakwah, Qiro'at) nah dari beberapa siswa dari masing-masing
kelas terdapat macam-macam pilihan siswa (Minimal 2 Pilihan).dalam rekapan saya
(sheet 1 : Pendaftaran) saya masukkan secara acak tanpa penyusunan per-kelas &
per-nama.saya mohon di sheet 2 Rekapan perlombaan Kelas untuk menyusunkan nama
nama siswa tergantung perlombaan pilihannya masing-masing termasuk
#yiv3519373974 -- #yiv3519373974ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3519373974
#yiv3519373974ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3519373974
#yiv3519373974ygrp-mkp #yiv3519373974hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3519373974 #yiv3519373974ygrp-mkp #yiv3519373974ads
{margin-bottom:10px;}#yiv3519373974 #yiv3519373974ygrp-mkp .yiv3519373974ad
{padding:0 0;}#yiv3519373974 #yiv3519373974ygrp-mkp .yiv3519373974ad p
{margin:0;}#yiv3519373974 #yiv3519373974ygrp-mkp .yiv3519373974ad a
{color:#0000ff;text-decoration:none;}#yiv3519373974 #yiv3519373974ygrp-sponsor
#yiv3519373974ygrp-lc {font-family:Arial;}#yiv3519373974
#yiv3519373974ygrp-sponsor #yiv3519373974ygrp-lc #yiv3519373974hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3519373974
#yiv3519373974ygrp-sponsor #yiv3519373974ygrp-lc .yiv3519373974ad
{margin-bottom:10px;padding:0 0;}#yiv3519373974 #yiv3519373974actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3519373974
#yiv3519373974activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3519373974
#yiv3519373974activity span {font-weight:700;}#yiv3519373974
#yiv3519373974activity span:first-child
{text-transform:uppercase;}#yiv3519373974 #yiv3519373974activity span a
{color:#5085b6;text-decoration:none;}#yiv3519373974 #yiv3519373974activity span
span {color:#ff7900;}#yiv3519373974 #yiv3519373974activity span
.yiv3519373974underline {text-decoration:underline;}#yiv3519373974
.yiv3519373974attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3519373974 .yiv3519373974attach div a
{text-decoration:none;}#yiv3519373974 .yiv3519373974attach img
{border:none;padding-right:5px;}#yiv3519373974 .yiv3519373974attach label
{display:block;margin-bottom:5px;}#yiv3519373974 .yiv3519373974attach label a
{text-decoration:none;}#yiv3519373974 blockquote {margin:0 0 0
4px;}#yiv3519373974 .yiv3519373974bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3519373974
.yiv3519373974bold a {text-decoration:none;}#yiv3519373974 dd.yiv3519373974last
p a {font-family:Verdana;font-weight:700;}#yiv3519373974 dd.yiv3519373974last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3519373974
dd.yiv3519373974last p span.yiv3519373974yshortcuts
{margin-right:0;}#yiv3519373974 div.yiv3519373974attach-table div div a
{text-decoration:none;}#yiv3519373974 div.yiv3519373974attach-table
{width:400px;}#yiv3519373974 div.yiv3519373974file-title a, #yiv3519373974
div.yiv3519373974file-title a:active, #yiv3519373974
div.yiv3519373974file-title a:hover, #yiv3519373974 div.yiv3519373974file-title
a:visited {text-decoration:none;}#yiv3519373974 div.yiv3519373974photo-title a,
#yiv3519373974 div.yiv3519373974photo-title a:active, #yiv3519373974
div.yiv3519373974photo-title a:hover, #yiv3519373974
div.yiv3519373974photo-title a:visited {text-decoration:none;}#yiv3519373974
div#yiv3519373974ygrp-mlmsg #yiv3519373974ygrp-msg p a
span.yiv3519373974yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3519373974
.yiv3519373974green {color:#628c2a;}#yiv3519373974 .yiv3519373974MsoNormal
{margin:0 0 0 0;}#yiv3519373974 o {font-size:0;}#yiv3519373974
#yiv3519373974photos div {float:left;width:72px;}#yiv3519373974
#yiv3519373974photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3519373974
#yiv3519373974photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3519373974
#yiv3519373974reco-category {font-size:77%;}#yiv3519373974
#yiv3519373974reco-desc {font-size:77%;}#yiv3519373974 .yiv3519373974replbq
{margin:4px;}#yiv3519373974 #yiv3519373974ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3519373974 #yiv3519373974ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3519373974
#yiv3519373974ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3519373974
#yiv3519373974ygrp-mlmsg select, #yiv3519373974 input, #yiv3519373974 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3519373974
#yiv3519373974ygrp-mlmsg pre, #yiv3519373974 code {font:115%
monospace;}#yiv3519373974 #yiv3519373974ygrp-mlmsg *
{line-height:1.22em;}#yiv3519373974 #yiv3519373974ygrp-mlmsg #yiv3519373974logo
{padding-bottom:10px;}#yiv3519373974 #yiv3519373974ygrp-msg p a
{font-family:Verdana;}#yiv3519373974 #yiv3519373974ygrp-msg
p#yiv3519373974attach-count span {color:#1E66AE;font-weight:700;}#yiv3519373974
#yiv3519373974ygrp-reco #yiv3519373974reco-head
{color:#ff7900;font-weight:700;}#yiv3519373974 #yiv3519373974ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3519373974 #yiv3519373974ygrp-sponsor
#yiv3519373974ov li a {font-size:130%;text-decoration:none;}#yiv3519373974
#yiv3519373974ygrp-sponsor #yiv3519373974ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3519373974
#yiv3519373974ygrp-sponsor #yiv3519373974ov ul {margin:0;padding:0 0 0
8px;}#yiv3519373974 #yiv3519373974ygrp-text
{font-family:Georgia;}#yiv3519373974 #yiv3519373974ygrp-text p {margin:0 0 1em
0;}#yiv3519373974 #yiv3519373974ygrp-text tt {font-size:120%;}#yiv3519373974
#yiv3519373974ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3519373974
