Dear Mas toby, utk batasan nilainya sbb, saya lampirkan excelnya ya, tetapi utk ranking tetap sy perlukan utk melihat prestasi per posisi :
| Nilai : |
| 1 - 10 = E |
| 11 - 20 = C |
| 20 - 30 = B |
| 30 - 40 = A |
Trmksh banyak
Salam
Pada Rabu, 22 April 2015 17:00, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> menulis:
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
#yiv3177399890 #yiv3177399890 -- #yiv3177399890ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3177399890
#yiv3177399890ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3177399890
#yiv3177399890ygrp-mkp #yiv3177399890hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3177399890 #yiv3177399890ygrp-mkp #yiv3177399890ads
{margin-bottom:10px;}#yiv3177399890 #yiv3177399890ygrp-mkp .yiv3177399890ad
{padding:0 0;}#yiv3177399890 #yiv3177399890ygrp-mkp .yiv3177399890ad p
{margin:0;}#yiv3177399890 #yiv3177399890ygrp-mkp .yiv3177399890ad a
{color:#0000ff;text-decoration:none;}#yiv3177399890 #yiv3177399890ygrp-sponsor
#yiv3177399890ygrp-lc {font-family:Arial;}#yiv3177399890
#yiv3177399890ygrp-sponsor #yiv3177399890ygrp-lc #yiv3177399890hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3177399890
#yiv3177399890ygrp-sponsor #yiv3177399890ygrp-lc .yiv3177399890ad
{margin-bottom:10px;padding:0 0;}#yiv3177399890 #yiv3177399890actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3177399890
#yiv3177399890activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3177399890
#yiv3177399890activity span {font-weight:700;}#yiv3177399890
#yiv3177399890activity span:first-child
{text-transform:uppercase;}#yiv3177399890 #yiv3177399890activity span a
{color:#5085b6;text-decoration:none;}#yiv3177399890 #yiv3177399890activity span
span {color:#ff7900;}#yiv3177399890 #yiv3177399890activity span
.yiv3177399890underline {text-decoration:underline;}#yiv3177399890
.yiv3177399890attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3177399890 .yiv3177399890attach div a
{text-decoration:none;}#yiv3177399890 .yiv3177399890attach img
{border:none;padding-right:5px;}#yiv3177399890 .yiv3177399890attach label
{display:block;margin-bottom:5px;}#yiv3177399890 .yiv3177399890attach label a
{text-decoration:none;}#yiv3177399890 blockquote {margin:0 0 0
4px;}#yiv3177399890 .yiv3177399890bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3177399890
.yiv3177399890bold a {text-decoration:none;}#yiv3177399890 dd.yiv3177399890last
p a {font-family:Verdana;font-weight:700;}#yiv3177399890 dd.yiv3177399890last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3177399890
dd.yiv3177399890last p span.yiv3177399890yshortcuts
{margin-right:0;}#yiv3177399890 div.yiv3177399890attach-table div div a
{text-decoration:none;}#yiv3177399890 div.yiv3177399890attach-table
{width:400px;}#yiv3177399890 div.yiv3177399890file-title a, #yiv3177399890
div.yiv3177399890file-title a:active, #yiv3177399890
div.yiv3177399890file-title a:hover, #yiv3177399890 div.yiv3177399890file-title
a:visited {text-decoration:none;}#yiv3177399890 div.yiv3177399890photo-title a,
#yiv3177399890 div.yiv3177399890photo-title a:active, #yiv3177399890
div.yiv3177399890photo-title a:hover, #yiv3177399890
div.yiv3177399890photo-title a:visited {text-decoration:none;}#yiv3177399890
div#yiv3177399890ygrp-mlmsg #yiv3177399890ygrp-msg p a
span.yiv3177399890yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3177399890
.yiv3177399890green {color:#628c2a;}#yiv3177399890 .yiv3177399890MsoNormal
{margin:0 0 0 0;}#yiv3177399890 o {font-size:0;}#yiv3177399890
#yiv3177399890photos div {float:left;width:72px;}#yiv3177399890
#yiv3177399890photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3177399890
#yiv3177399890photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3177399890
#yiv3177399890reco-category {font-size:77%;}#yiv3177399890
#yiv3177399890reco-desc {font-size:77%;}#yiv3177399890 .yiv3177399890replbq
{margin:4px;}#yiv3177399890 #yiv3177399890ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3177399890 #yiv3177399890ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3177399890
#yiv3177399890ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3177399890
#yiv3177399890ygrp-mlmsg select, #yiv3177399890 input, #yiv3177399890 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3177399890
#yiv3177399890ygrp-mlmsg pre, #yiv3177399890 code {font:115%
monospace;}#yiv3177399890 #yiv3177399890ygrp-mlmsg *
{line-height:1.22em;}#yiv3177399890 #yiv3177399890ygrp-mlmsg #yiv3177399890logo
{padding-bottom:10px;}#yiv3177399890 #yiv3177399890ygrp-msg p a
{font-family:Verdana;}#yiv3177399890 #yiv3177399890ygrp-msg
p#yiv3177399890attach-count span {color:#1E66AE;font-weight:700;}#yiv3177399890
#yiv3177399890ygrp-reco #yiv3177399890reco-head
{color:#ff7900;font-weight:700;}#yiv3177399890 #yiv3177399890ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3177399890 #yiv3177399890ygrp-sponsor
#yiv3177399890ov li a {font-size:130%;text-decoration:none;}#yiv3177399890
#yiv3177399890ygrp-sponsor #yiv3177399890ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3177399890
#yiv3177399890ygrp-sponsor #yiv3177399890ov ul {margin:0;padding:0 0 0
8px;}#yiv3177399890 #yiv3177399890ygrp-text
{font-family:Georgia;}#yiv3177399890 #yiv3177399890ygrp-text p {margin:0 0 1em
0;}#yiv3177399890 #yiv3177399890ygrp-text tt {font-size:120%;}#yiv3177399890
#yiv3177399890ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3177399890
Cara Ranking Berdasarkan Posisi.xlsx
Description: MS-Excel 2007 spreadsheet
