Yth. Mr. Kid terimakasih penyelesaian nya.
Oiya Mr. Kid, file data dummy yg saya kirim itu hanya satu matakuliah (bedah).
Sementara file data aslinya itu terdiri dari 16 matakuliah (1 sheet = 1
matakuliah, jadi ada 16 sheet matakuliah, 1 sheet gabung). Andaikata,
penyelesaian Mr. Kid tsb (ada array formula nya) saya terapkan ke sheet
matakuliah yg lain, apakah sangat memberatkan fungsi kerja excelnya ? Adakah
solusinya ?
Informasi :- file data asli saat ini berukuran 2.5-3 MB- 1 sheet gabung, tdpt
macro gabung sheet, hasil gabung format Excel tablet- 16 sheet matakuliah,
tidak ada pengaturan Border Cell, ada fungsi conditional formatting di satu
kolom.
Terimakasih, mohon pencerahannya lagi.
Dikirim dari Yahoo Mail di Android
Pada Jum, 16 Mar 2018 pada 11:15, 'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]<belajar-excel@yahoogroups.com> menulis:
Wa'alaikumussalam wr wb
File terlampir menggunakan kolom helper dan ada yang berisi array formula
dengan running (resizing) references.
Wassalamu'alaikum wr wb
Kid
2018-03-01 13:08 GMT+07:00 cheivory_bri...@yahoo.com [belajar-excel]
<belajar-excel@yahoogroups.com>:
Yth. B-Exceler
Assalaamu'alaikum Wr Wb
Mohon kiranya dapat dibantu mendapatkan informasi deteksi waktu tandem.
Case terlampir.
Terima kasih.
Wassalaamu'alaikum Wr Wb
Ari
#yiv9007769558 #yiv9007769558 -- #yiv9007769558ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9007769558
#yiv9007769558ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9007769558
#yiv9007769558ygrp-mkp #yiv9007769558hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9007769558 #yiv9007769558ygrp-mkp #yiv9007769558ads
{margin-bottom:10px;}#yiv9007769558 #yiv9007769558ygrp-mkp .yiv9007769558ad
{padding:0 0;}#yiv9007769558 #yiv9007769558ygrp-mkp .yiv9007769558ad p
{margin:0;}#yiv9007769558 #yiv9007769558ygrp-mkp .yiv9007769558ad a
{color:#0000ff;text-decoration:none;}#yiv9007769558 #yiv9007769558ygrp-sponsor
#yiv9007769558ygrp-lc {font-family:Arial;}#yiv9007769558
#yiv9007769558ygrp-sponsor #yiv9007769558ygrp-lc #yiv9007769558hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9007769558
#yiv9007769558ygrp-sponsor #yiv9007769558ygrp-lc .yiv9007769558ad
{margin-bottom:10px;padding:0 0;}#yiv9007769558 #yiv9007769558actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9007769558
#yiv9007769558activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9007769558
#yiv9007769558activity span {font-weight:700;}#yiv9007769558
#yiv9007769558activity span:first-child
{text-transform:uppercase;}#yiv9007769558 #yiv9007769558activity span a
{color:#5085b6;text-decoration:none;}#yiv9007769558 #yiv9007769558activity span
span {color:#ff7900;}#yiv9007769558 #yiv9007769558activity span
.yiv9007769558underline {text-decoration:underline;}#yiv9007769558
.yiv9007769558attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9007769558 .yiv9007769558attach div a
{text-decoration:none;}#yiv9007769558 .yiv9007769558attach img
{border:none;padding-right:5px;}#yiv9007769558 .yiv9007769558attach label
{display:block;margin-bottom:5px;}#yiv9007769558 .yiv9007769558attach label a
{text-decoration:none;}#yiv9007769558 blockquote {margin:0 0 0
4px;}#yiv9007769558 .yiv9007769558bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9007769558
.yiv9007769558bold a {text-decoration:none;}#yiv9007769558 dd.yiv9007769558last
p a {font-family:Verdana;font-weight:700;}#yiv9007769558 dd.yiv9007769558last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9007769558
dd.yiv9007769558last p span.yiv9007769558yshortcuts
{margin-right:0;}#yiv9007769558 div.yiv9007769558attach-table div div a
{text-decoration:none;}#yiv9007769558 div.yiv9007769558attach-table
{width:400px;}#yiv9007769558 div.yiv9007769558file-title a, #yiv9007769558
div.yiv9007769558file-title a:active, #yiv9007769558
div.yiv9007769558file-title a:hover, #yiv9007769558 div.yiv9007769558file-title
a:visited {text-decoration:none;}#yiv9007769558 div.yiv9007769558photo-title a,
#yiv9007769558 div.yiv9007769558photo-title a:active, #yiv9007769558
div.yiv9007769558photo-title a:hover, #yiv9007769558
div.yiv9007769558photo-title a:visited {text-decoration:none;}#yiv9007769558
div#yiv9007769558ygrp-mlmsg #yiv9007769558ygrp-msg p a
span.yiv9007769558yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9007769558
.yiv9007769558green {color:#628c2a;}#yiv9007769558 .yiv9007769558MsoNormal
{margin:0 0 0 0;}#yiv9007769558 o {font-size:0;}#yiv9007769558
#yiv9007769558photos div {float:left;width:72px;}#yiv9007769558
#yiv9007769558photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv9007769558
#yiv9007769558photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9007769558
#yiv9007769558reco-category {font-size:77%;}#yiv9007769558
#yiv9007769558reco-desc {font-size:77%;}#yiv9007769558 .yiv9007769558replbq
{margin:4px;}#yiv9007769558 #yiv9007769558ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9007769558 #yiv9007769558ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9007769558
#yiv9007769558ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9007769558
#yiv9007769558ygrp-mlmsg select, #yiv9007769558 input, #yiv9007769558 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9007769558
#yiv9007769558ygrp-mlmsg pre, #yiv9007769558 code {font:115%
monospace;}#yiv9007769558 #yiv9007769558ygrp-mlmsg *
{line-height:1.22em;}#yiv9007769558 #yiv9007769558ygrp-mlmsg #yiv9007769558logo
{padding-bottom:10px;}#yiv9007769558 #yiv9007769558ygrp-msg p a
{font-family:Verdana;}#yiv9007769558 #yiv9007769558ygrp-msg
p#yiv9007769558attach-count span {color:#1E66AE;font-weight:700;}#yiv9007769558
#yiv9007769558ygrp-reco #yiv9007769558reco-head
{color:#ff7900;font-weight:700;}#yiv9007769558 #yiv9007769558ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9007769558 #yiv9007769558ygrp-sponsor
#yiv9007769558ov li a {font-size:130%;text-decoration:none;}#yiv9007769558
#yiv9007769558ygrp-sponsor #yiv9007769558ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9007769558
#yiv9007769558ygrp-sponsor #yiv9007769558ov ul {margin:0;padding:0 0 0
8px;}#yiv9007769558 #yiv9007769558ygrp-text
{font-family:Georgia;}#yiv9007769558 #yiv9007769558ygrp-text p {margin:0 0 1em
0;}#yiv9007769558 #yiv9007769558ygrp-text tt {font-size:120%;}#yiv9007769558
#yiv9007769558ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9007769558
