pak agus, takcoba dulu ya
rekan rekan lain.. jika berkenan serta waktu luang dan membantu kesulitanku ....
apalagi jika mr Kid dan teamnya turun gunung.. waduhhh senengnya.. kee
tksmakdo
Pada Jumat, 29 Mei 2015 8:23, "Nang Agus [email protected]
[belajar-excel]" <[email protected]> menulis:
Dear Doner,
kalau gak mau pakai array berarti harus pakai kolom bantu dong.coba di sheet
input absen dibuat kolom bantu di kolom P. tulis di P2 dengan formula:
=B2&D2Kopi ke bawah.
Di sheet tabulasi absen harian pada cell E7 ketik formula:
=IF(MOD(E$6;7)<2;"-";IF(ISNUMBER(INDEX('input absen
'!$G$2:$G$551;MATCH('tabulasi absensi harian'!$B7&TEXT(E$6;"m/d/yyyy");'input
absen '!$P$2:$P$551;0))*1);1;INDEX('input absen '!$G$2:$G$551;MATCH('tabulasi
absensi harian'!$B7&TEXT(E$6;"m/d/yyyy");'input absen '!$P$2:$P$551;0))))
jangan lupa ganti karakter ; menjadi , jika regional seting komputer berbahasa
inggris.
Sebenarnya formula tersebut dapat bejkerja tanpa kolom bantu dengan sedikit
perubahan, namun harus menggunakan array formula.kita tunggu saja jawaban dari
rekan-rekan lainnya.salam
2015-05-28 16:35 GMT+07:00 Doner santoso [email protected] [belajar-excel]
<[email protected]>:
Dear suhu dan sepuh sepuh excel Selamat siang,
Dikarenakan saya kerjanya hanya seputar penggajian dan adminitrasi HRD
maka maafkan jika tentang hal hal itu saja yang saya tanyakan. jangan bosan
ya.. hee
Dear suhu dan sepuh sepuh excel tolong dibantu bagaiman membuat tabulasi absen
atomatis ( file terlampir)Dengan ketentuan
- Mengacu kepada “input absen “ kolom Gdan atau H , jika ada jam kerja
maka pada tabulasi di berikode 1 sesusai tanggal tersebut
- Sabtu dan mingguadalah libur jadi diberi tanda “ - “ (tanda setrip saja)
- Jika adatertulis pada “ input absen” kolom G tertulis A, CT, S, C, CH,
D, CB, CM, CP maka pada tabulasi sama
oh iya kalau bisa jangan pakai macro & array ya
Mohon dibantu ya rekan rekan , karena saya lagi semangat mangatnya kerja
makanya banyak Tanya Terimakasih DS
#yiv6006023393 #yiv6006023393 -- #yiv6006023393ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6006023393
#yiv6006023393ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6006023393
#yiv6006023393ygrp-mkp #yiv6006023393hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6006023393 #yiv6006023393ygrp-mkp #yiv6006023393ads
{margin-bottom:10px;}#yiv6006023393 #yiv6006023393ygrp-mkp .yiv6006023393ad
{padding:0 0;}#yiv6006023393 #yiv6006023393ygrp-mkp .yiv6006023393ad p
{margin:0;}#yiv6006023393 #yiv6006023393ygrp-mkp .yiv6006023393ad a
{color:#0000ff;text-decoration:none;}#yiv6006023393 #yiv6006023393ygrp-sponsor
#yiv6006023393ygrp-lc {font-family:Arial;}#yiv6006023393
#yiv6006023393ygrp-sponsor #yiv6006023393ygrp-lc #yiv6006023393hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6006023393
#yiv6006023393ygrp-sponsor #yiv6006023393ygrp-lc .yiv6006023393ad
{margin-bottom:10px;padding:0 0;}#yiv6006023393 #yiv6006023393actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6006023393
#yiv6006023393activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6006023393
#yiv6006023393activity span {font-weight:700;}#yiv6006023393
#yiv6006023393activity span:first-child
{text-transform:uppercase;}#yiv6006023393 #yiv6006023393activity span a
{color:#5085b6;text-decoration:none;}#yiv6006023393 #yiv6006023393activity span
span {color:#ff7900;}#yiv6006023393 #yiv6006023393activity span
.yiv6006023393underline {text-decoration:underline;}#yiv6006023393
.yiv6006023393attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6006023393 .yiv6006023393attach div a
{text-decoration:none;}#yiv6006023393 .yiv6006023393attach img
{border:none;padding-right:5px;}#yiv6006023393 .yiv6006023393attach label
{display:block;margin-bottom:5px;}#yiv6006023393 .yiv6006023393attach label a
{text-decoration:none;}#yiv6006023393 blockquote {margin:0 0 0
4px;}#yiv6006023393 .yiv6006023393bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6006023393
.yiv6006023393bold a {text-decoration:none;}#yiv6006023393 dd.yiv6006023393last
p a {font-family:Verdana;font-weight:700;}#yiv6006023393 dd.yiv6006023393last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6006023393
dd.yiv6006023393last p span.yiv6006023393yshortcuts
{margin-right:0;}#yiv6006023393 div.yiv6006023393attach-table div div a
{text-decoration:none;}#yiv6006023393 div.yiv6006023393attach-table
{width:400px;}#yiv6006023393 div.yiv6006023393file-title a, #yiv6006023393
div.yiv6006023393file-title a:active, #yiv6006023393
div.yiv6006023393file-title a:hover, #yiv6006023393 div.yiv6006023393file-title
a:visited {text-decoration:none;}#yiv6006023393 div.yiv6006023393photo-title a,
#yiv6006023393 div.yiv6006023393photo-title a:active, #yiv6006023393
div.yiv6006023393photo-title a:hover, #yiv6006023393
div.yiv6006023393photo-title a:visited {text-decoration:none;}#yiv6006023393
div#yiv6006023393ygrp-mlmsg #yiv6006023393ygrp-msg p a
span.yiv6006023393yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6006023393
.yiv6006023393green {color:#628c2a;}#yiv6006023393 .yiv6006023393MsoNormal
{margin:0 0 0 0;}#yiv6006023393 o {font-size:0;}#yiv6006023393
#yiv6006023393photos div {float:left;width:72px;}#yiv6006023393
#yiv6006023393photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv6006023393
#yiv6006023393photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6006023393
#yiv6006023393reco-category {font-size:77%;}#yiv6006023393
#yiv6006023393reco-desc {font-size:77%;}#yiv6006023393 .yiv6006023393replbq
{margin:4px;}#yiv6006023393 #yiv6006023393ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6006023393 #yiv6006023393ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6006023393
#yiv6006023393ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6006023393
#yiv6006023393ygrp-mlmsg select, #yiv6006023393 input, #yiv6006023393 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6006023393
#yiv6006023393ygrp-mlmsg pre, #yiv6006023393 code {font:115%
monospace;}#yiv6006023393 #yiv6006023393ygrp-mlmsg *
{line-height:1.22em;}#yiv6006023393 #yiv6006023393ygrp-mlmsg #yiv6006023393logo
{padding-bottom:10px;}#yiv6006023393 #yiv6006023393ygrp-msg p a
{font-family:Verdana;}#yiv6006023393 #yiv6006023393ygrp-msg
p#yiv6006023393attach-count span {color:#1E66AE;font-weight:700;}#yiv6006023393
#yiv6006023393ygrp-reco #yiv6006023393reco-head
{color:#ff7900;font-weight:700;}#yiv6006023393 #yiv6006023393ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6006023393 #yiv6006023393ygrp-sponsor
#yiv6006023393ov li a {font-size:130%;text-decoration:none;}#yiv6006023393
#yiv6006023393ygrp-sponsor #yiv6006023393ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6006023393
#yiv6006023393ygrp-sponsor #yiv6006023393ov ul {margin:0;padding:0 0 0
8px;}#yiv6006023393 #yiv6006023393ygrp-text
{font-family:Georgia;}#yiv6006023393 #yiv6006023393ygrp-text p {margin:0 0 1em
0;}#yiv6006023393 #yiv6006023393ygrp-text tt {font-size:120%;}#yiv6006023393
#yiv6006023393ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6006023393
