Dear Eko, Untuk memudahkan perhitungan, sebisa mungkin di buat kolom bantu
untuk masing2 posisi, contoh mungkin setiap posisi di beri keterangan untuk
Gradenya atau batasan gradenya, contoh lagi, misal untuk nilai 1 sampai 10
untuk grade A sama dengan nilai 10 sampai 15 pada grade B, dengan begitu tidak
membutuhkan banyak formula. TerimaKasih.
Pada Rabu, 22 April 2015 15:56, "Eko Budhi [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear mas toby,
Terimakasih banyak sebelumnya, utk case ini sy sdh kurangi jumlah karyawannya,
kalau misal jumlahnya lebih dari 200 orang kira2 ada alternatif formula lainnya
? trmksh
Salam,
Eko
Pada Rabu, 22 April 2015 15:36, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Eko, Mungkin file ini bisa membantu. TerimaKasih.
Pada Rabu, 22 April 2015 10:04, "Eko Budhi [email protected]
[belajar-excel]" <[email protected]> menulis:
Yth pakar2 B-Excel,
Mohon bantuan nya utk membuat ranking tapi berdasarkan posisi sesuai lampiran,
acuanya ada di kolom D & C. sebelum dan sesudahnya saya sampaikan terimakasih
kasih banyak atas ilmunya
Salam,
Eko
#yiv3106514079 #yiv3106514079 -- #yiv3106514079ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3106514079
#yiv3106514079ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3106514079
#yiv3106514079ygrp-mkp #yiv3106514079hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3106514079 #yiv3106514079ygrp-mkp #yiv3106514079ads
{margin-bottom:10px;}#yiv3106514079 #yiv3106514079ygrp-mkp .yiv3106514079ad
{padding:0 0;}#yiv3106514079 #yiv3106514079ygrp-mkp .yiv3106514079ad p
{margin:0;}#yiv3106514079 #yiv3106514079ygrp-mkp .yiv3106514079ad a
{color:#0000ff;text-decoration:none;}#yiv3106514079 #yiv3106514079ygrp-sponsor
#yiv3106514079ygrp-lc {font-family:Arial;}#yiv3106514079
#yiv3106514079ygrp-sponsor #yiv3106514079ygrp-lc #yiv3106514079hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3106514079
#yiv3106514079ygrp-sponsor #yiv3106514079ygrp-lc .yiv3106514079ad
{margin-bottom:10px;padding:0 0;}#yiv3106514079 #yiv3106514079actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3106514079
#yiv3106514079activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3106514079
#yiv3106514079activity span {font-weight:700;}#yiv3106514079
#yiv3106514079activity span:first-child
{text-transform:uppercase;}#yiv3106514079 #yiv3106514079activity span a
{color:#5085b6;text-decoration:none;}#yiv3106514079 #yiv3106514079activity span
span {color:#ff7900;}#yiv3106514079 #yiv3106514079activity span
.yiv3106514079underline {text-decoration:underline;}#yiv3106514079
.yiv3106514079attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3106514079 .yiv3106514079attach div a
{text-decoration:none;}#yiv3106514079 .yiv3106514079attach img
{border:none;padding-right:5px;}#yiv3106514079 .yiv3106514079attach label
{display:block;margin-bottom:5px;}#yiv3106514079 .yiv3106514079attach label a
{text-decoration:none;}#yiv3106514079 blockquote {margin:0 0 0
4px;}#yiv3106514079 .yiv3106514079bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3106514079
.yiv3106514079bold a {text-decoration:none;}#yiv3106514079 dd.yiv3106514079last
p a {font-family:Verdana;font-weight:700;}#yiv3106514079 dd.yiv3106514079last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3106514079
dd.yiv3106514079last p span.yiv3106514079yshortcuts
{margin-right:0;}#yiv3106514079 div.yiv3106514079attach-table div div a
{text-decoration:none;}#yiv3106514079 div.yiv3106514079attach-table
{width:400px;}#yiv3106514079 div.yiv3106514079file-title a, #yiv3106514079
div.yiv3106514079file-title a:active, #yiv3106514079
div.yiv3106514079file-title a:hover, #yiv3106514079 div.yiv3106514079file-title
a:visited {text-decoration:none;}#yiv3106514079 div.yiv3106514079photo-title a,
#yiv3106514079 div.yiv3106514079photo-title a:active, #yiv3106514079
div.yiv3106514079photo-title a:hover, #yiv3106514079
div.yiv3106514079photo-title a:visited {text-decoration:none;}#yiv3106514079
div#yiv3106514079ygrp-mlmsg #yiv3106514079ygrp-msg p a
span.yiv3106514079yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3106514079
.yiv3106514079green {color:#628c2a;}#yiv3106514079 .yiv3106514079MsoNormal
{margin:0 0 0 0;}#yiv3106514079 o {font-size:0;}#yiv3106514079
#yiv3106514079photos div {float:left;width:72px;}#yiv3106514079
#yiv3106514079photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3106514079
#yiv3106514079photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3106514079
#yiv3106514079reco-category {font-size:77%;}#yiv3106514079
#yiv3106514079reco-desc {font-size:77%;}#yiv3106514079 .yiv3106514079replbq
{margin:4px;}#yiv3106514079 #yiv3106514079ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3106514079 #yiv3106514079ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3106514079
#yiv3106514079ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3106514079
#yiv3106514079ygrp-mlmsg select, #yiv3106514079 input, #yiv3106514079 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3106514079
#yiv3106514079ygrp-mlmsg pre, #yiv3106514079 code {font:115%
monospace;}#yiv3106514079 #yiv3106514079ygrp-mlmsg *
{line-height:1.22em;}#yiv3106514079 #yiv3106514079ygrp-mlmsg #yiv3106514079logo
{padding-bottom:10px;}#yiv3106514079 #yiv3106514079ygrp-msg p a
{font-family:Verdana;}#yiv3106514079 #yiv3106514079ygrp-msg
p#yiv3106514079attach-count span {color:#1E66AE;font-weight:700;}#yiv3106514079
#yiv3106514079ygrp-reco #yiv3106514079reco-head
{color:#ff7900;font-weight:700;}#yiv3106514079 #yiv3106514079ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3106514079 #yiv3106514079ygrp-sponsor
#yiv3106514079ov li a {font-size:130%;text-decoration:none;}#yiv3106514079
#yiv3106514079ygrp-sponsor #yiv3106514079ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3106514079
#yiv3106514079ygrp-sponsor #yiv3106514079ov ul {margin:0;padding:0 0 0
8px;}#yiv3106514079 #yiv3106514079ygrp-text
{font-family:Georgia;}#yiv3106514079 #yiv3106514079ygrp-text p {margin:0 0 1em
0;}#yiv3106514079 #yiv3106514079ygrp-text tt {font-size:120%;}#yiv3106514079
#yiv3106514079ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3106514079
