Yth. Mr. Kid Assalaamu'alaikum Wr Wb Mohon bantuan penyelesaiannya.Kasus terlampir, merujuk penyelesaian dari Mr. Kid yang terdahulu, hasilnya ada yang tak sesuai.Hasil bisa sesuai keinginan, (dengan catatan) apabila kolom tanggal mulai harus di sort Oldest --> newest. Tetapi, kalau dengan solusi tersebut akan terasa sulit mengetahui keterangan deteksi tandem dikarenakan data tersusun urut sesuai kolom tanggal mulai. (data lumayan banyak)Keinginannya apabila kita menginput suatu data maka hasil keterangan deteksi tandem langsung diketahui tanpa harus data tersusun urut sesuai kolom tanggal mulai. Mohon berkenan memberi pencerahan atas kasus tersebut.
Terima kasih.
Wassalaamu'alaikum Wr Wb
Ari
On Friday, March 16, 2018, 11:15:02 AM GMT+7, 'Mr. Kid' mr.nm...@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:
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
#yiv9842441458 #yiv9842441458 -- #yiv9842441458ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9842441458
#yiv9842441458ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9842441458
#yiv9842441458ygrp-mkp #yiv9842441458hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9842441458 #yiv9842441458ygrp-mkp #yiv9842441458ads
{margin-bottom:10px;}#yiv9842441458 #yiv9842441458ygrp-mkp .yiv9842441458ad
{padding:0 0;}#yiv9842441458 #yiv9842441458ygrp-mkp .yiv9842441458ad p
{margin:0;}#yiv9842441458 #yiv9842441458ygrp-mkp .yiv9842441458ad a
{color:#0000ff;text-decoration:none;}#yiv9842441458 #yiv9842441458ygrp-sponsor
#yiv9842441458ygrp-lc {font-family:Arial;}#yiv9842441458
#yiv9842441458ygrp-sponsor #yiv9842441458ygrp-lc #yiv9842441458hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9842441458
#yiv9842441458ygrp-sponsor #yiv9842441458ygrp-lc .yiv9842441458ad
{margin-bottom:10px;padding:0 0;}#yiv9842441458 #yiv9842441458actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9842441458
#yiv9842441458activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9842441458
#yiv9842441458activity span {font-weight:700;}#yiv9842441458
#yiv9842441458activity span:first-child
{text-transform:uppercase;}#yiv9842441458 #yiv9842441458activity span a
{color:#5085b6;text-decoration:none;}#yiv9842441458 #yiv9842441458activity span
span {color:#ff7900;}#yiv9842441458 #yiv9842441458activity span
.yiv9842441458underline {text-decoration:underline;}#yiv9842441458
.yiv9842441458attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9842441458 .yiv9842441458attach div a
{text-decoration:none;}#yiv9842441458 .yiv9842441458attach img
{border:none;padding-right:5px;}#yiv9842441458 .yiv9842441458attach label
{display:block;margin-bottom:5px;}#yiv9842441458 .yiv9842441458attach label a
{text-decoration:none;}#yiv9842441458 blockquote {margin:0 0 0
4px;}#yiv9842441458 .yiv9842441458bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9842441458
.yiv9842441458bold a {text-decoration:none;}#yiv9842441458 dd.yiv9842441458last
p a {font-family:Verdana;font-weight:700;}#yiv9842441458 dd.yiv9842441458last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9842441458
dd.yiv9842441458last p span.yiv9842441458yshortcuts
{margin-right:0;}#yiv9842441458 div.yiv9842441458attach-table div div a
{text-decoration:none;}#yiv9842441458 div.yiv9842441458attach-table
{width:400px;}#yiv9842441458 div.yiv9842441458file-title a, #yiv9842441458
div.yiv9842441458file-title a:active, #yiv9842441458
div.yiv9842441458file-title a:hover, #yiv9842441458 div.yiv9842441458file-title
a:visited {text-decoration:none;}#yiv9842441458 div.yiv9842441458photo-title a,
#yiv9842441458 div.yiv9842441458photo-title a:active, #yiv9842441458
div.yiv9842441458photo-title a:hover, #yiv9842441458
div...yiv9842441458photo-title a:visited {text-decoration:none;}#yiv9842441458
div#yiv9842441458ygrp-mlmsg #yiv9842441458ygrp-msg p a
span.yiv9842441458yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9842441458
.yiv9842441458green {color:#628c2a;}#yiv9842441458 .yiv9842441458MsoNormal
{margin:0 0 0 0;}#yiv9842441458 o {font-size:0;}#yiv9842441458
#yiv9842441458photos div {float:left;width:72px;}#yiv9842441458
#yiv9842441458photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv9842441458
#yiv9842441458photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9842441458
#yiv9842441458reco-category {font-size:77%;}#yiv9842441458
#yiv9842441458reco-desc {font-size:77%;}#yiv9842441458 .yiv9842441458replbq
{margin:4px;}#yiv9842441458 #yiv9842441458ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9842441458 #yiv9842441458ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9842441458
#yiv9842441458ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9842441458
#yiv9842441458ygrp-mlmsg select, #yiv9842441458 input, #yiv9842441458 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9842441458
#yiv9842441458ygrp-mlmsg pre, #yiv9842441458 code {font:115%
monospace;}#yiv9842441458 #yiv9842441458ygrp-mlmsg *
{line-height:1.22em;}#yiv9842441458 #yiv9842441458ygrp-mlmsg #yiv9842441458logo
{padding-bottom:10px;}#yiv9842441458 #yiv9842441458ygrp-msg p a
{font-family:Verdana;}#yiv9842441458 #yiv9842441458ygrp-msg
p#yiv9842441458attach-count span {color:#1E66AE;font-weight:700;}#yiv9842441458
#yiv9842441458ygrp-reco #yiv9842441458reco-head
{color:#ff7900;font-weight:700;}#yiv9842441458 #yiv9842441458ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9842441458 #yiv9842441458ygrp-sponsor
#yiv9842441458ov li a {font-size:130%;text-decoration:none;}#yiv9842441458
#yiv9842441458ygrp-sponsor #yiv9842441458ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9842441458
#yiv9842441458ygrp-sponsor #yiv9842441458ov ul {margin:0;padding:0 0 0
8px;}#yiv9842441458 #yiv9842441458ygrp-text
{font-family:Georgia;}#yiv9842441458 #yiv9842441458ygrp-text p {margin:0 0 1em
0;}#yiv9842441458 #yiv9842441458ygrp-text tt {font-size:120%;}#yiv9842441458
#yiv9842441458ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9842441458
re-deteksi tandem.xlsx
Description: MS-Excel 2007 spreadsheet
