dear all keluarga Belajar exceldan Mr kid, Toby, nang agus serta suhu suhu
yang lainya
Terimkasih atas bantuannya
TksDS
Pada Jumat, 29 Mei 2015 18:10, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
File lampirannya yang berisi formula : (aji mumpung...)
=IF(MOD(E$6,7)>1,IF(COUNTIFS('input absen '!$B$2:$B$551,$B7,'input absen
'!$D$2:$D$551,TEXT(E$6,"m/d/yyyy"),'input absen
'!$I$2:$I$551,"?*"),LOOKUP(2,1/(('input absen '!$B$2:$B$551=$B7)*('input absen
'!$D$2:$D$551=TEXT(E$6,"m/d/yyyy"))),'input absen '!$I$2:$I$551),1),"-")
2015-05-29 19:37 GMT+10:00 Mr. Kid <[email protected]>:
Hai Doner,
Mungkin begini : (tanpa kolom bantu dan moga-moga ndak ada yang kliru) [range
hasil di E7]
=IF(MOD(E$6,7)>1,IF(COUNTIFS('input absen '!$B$2:$B$551,$B7,'input absen
'!$D$2:$D$551,TEXT(E$6,"m/d/yyyy"),'input absen
'!$I$2:$I$551,"?*"),LOOKUP(2,1/(('input absen '!$B$2:$B$551=$B7)*('input absen
'!$D$2:$D$551=TEXT(E$6,"m/d/yyyy"))),'input absen '!$I$2:$I$551),1),"-")
Wassalam,
Kid
2015-05-28 19:35 GMT+10: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
#yiv7277009880 #yiv7277009880 -- #yiv7277009880ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7277009880
#yiv7277009880ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7277009880
#yiv7277009880ygrp-mkp #yiv7277009880hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7277009880 #yiv7277009880ygrp-mkp #yiv7277009880ads
{margin-bottom:10px;}#yiv7277009880 #yiv7277009880ygrp-mkp .yiv7277009880ad
{padding:0 0;}#yiv7277009880 #yiv7277009880ygrp-mkp .yiv7277009880ad p
{margin:0;}#yiv7277009880 #yiv7277009880ygrp-mkp .yiv7277009880ad a
{color:#0000ff;text-decoration:none;}#yiv7277009880 #yiv7277009880ygrp-sponsor
#yiv7277009880ygrp-lc {font-family:Arial;}#yiv7277009880
#yiv7277009880ygrp-sponsor #yiv7277009880ygrp-lc #yiv7277009880hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7277009880
#yiv7277009880ygrp-sponsor #yiv7277009880ygrp-lc .yiv7277009880ad
{margin-bottom:10px;padding:0 0;}#yiv7277009880 #yiv7277009880actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7277009880
#yiv7277009880activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7277009880
#yiv7277009880activity span {font-weight:700;}#yiv7277009880
#yiv7277009880activity span:first-child
{text-transform:uppercase;}#yiv7277009880 #yiv7277009880activity span a
{color:#5085b6;text-decoration:none;}#yiv7277009880 #yiv7277009880activity span
span {color:#ff7900;}#yiv7277009880 #yiv7277009880activity span
.yiv7277009880underline {text-decoration:underline;}#yiv7277009880
.yiv7277009880attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7277009880 .yiv7277009880attach div a
{text-decoration:none;}#yiv7277009880 .yiv7277009880attach img
{border:none;padding-right:5px;}#yiv7277009880 .yiv7277009880attach label
{display:block;margin-bottom:5px;}#yiv7277009880 .yiv7277009880attach label a
{text-decoration:none;}#yiv7277009880 blockquote {margin:0 0 0
4px;}#yiv7277009880 .yiv7277009880bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7277009880
.yiv7277009880bold a {text-decoration:none;}#yiv7277009880 dd.yiv7277009880last
p a {font-family:Verdana;font-weight:700;}#yiv7277009880 dd.yiv7277009880last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7277009880
dd.yiv7277009880last p span.yiv7277009880yshortcuts
{margin-right:0;}#yiv7277009880 div.yiv7277009880attach-table div div a
{text-decoration:none;}#yiv7277009880 div.yiv7277009880attach-table
{width:400px;}#yiv7277009880 div.yiv7277009880file-title a, #yiv7277009880
div.yiv7277009880file-title a:active, #yiv7277009880
div.yiv7277009880file-title a:hover, #yiv7277009880 div.yiv7277009880file-title
a:visited {text-decoration:none;}#yiv7277009880 div.yiv7277009880photo-title a,
#yiv7277009880 div.yiv7277009880photo-title a:active, #yiv7277009880
div.yiv7277009880photo-title a:hover, #yiv7277009880
div.yiv7277009880photo-title a:visited {text-decoration:none;}#yiv7277009880
div#yiv7277009880ygrp-mlmsg #yiv7277009880ygrp-msg p a
span.yiv7277009880yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7277009880
.yiv7277009880green {color:#628c2a;}#yiv7277009880 .yiv7277009880MsoNormal
{margin:0 0 0 0;}#yiv7277009880 o {font-size:0;}#yiv7277009880
#yiv7277009880photos div {float:left;width:72px;}#yiv7277009880
#yiv7277009880photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7277009880
#yiv7277009880photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7277009880
#yiv7277009880reco-category {font-size:77%;}#yiv7277009880
#yiv7277009880reco-desc {font-size:77%;}#yiv7277009880 .yiv7277009880replbq
{margin:4px;}#yiv7277009880 #yiv7277009880ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7277009880 #yiv7277009880ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7277009880
#yiv7277009880ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7277009880
#yiv7277009880ygrp-mlmsg select, #yiv7277009880 input, #yiv7277009880 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7277009880
#yiv7277009880ygrp-mlmsg pre, #yiv7277009880 code {font:115%
monospace;}#yiv7277009880 #yiv7277009880ygrp-mlmsg *
{line-height:1.22em;}#yiv7277009880 #yiv7277009880ygrp-mlmsg #yiv7277009880logo
{padding-bottom:10px;}#yiv7277009880 #yiv7277009880ygrp-msg p a
{font-family:Verdana;}#yiv7277009880 #yiv7277009880ygrp-msg
p#yiv7277009880attach-count span {color:#1E66AE;font-weight:700;}#yiv7277009880
#yiv7277009880ygrp-reco #yiv7277009880reco-head
{color:#ff7900;font-weight:700;}#yiv7277009880 #yiv7277009880ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7277009880 #yiv7277009880ygrp-sponsor
#yiv7277009880ov li a {font-size:130%;text-decoration:none;}#yiv7277009880
#yiv7277009880ygrp-sponsor #yiv7277009880ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7277009880
#yiv7277009880ygrp-sponsor #yiv7277009880ov ul {margin:0;padding:0 0 0
8px;}#yiv7277009880 #yiv7277009880ygrp-text
{font-family:Georgia;}#yiv7277009880 #yiv7277009880ygrp-text p {margin:0 0 1em
0;}#yiv7277009880 #yiv7277009880ygrp-text tt {font-size:120%;}#yiv7277009880
#yiv7277009880ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7277009880
